Skip to main content
I
IrinaDragusanu
May 1, 2025
Solved

Lookup Transformational rule UNDO

  • May 1, 2025
  • 2 replies
  • 0 views

Hello. I have a set of Lookup Transformational rules. I have tried to load a mass upload for multiple lines of transformational rules through a trx file. I had a message saying the load has been completed with errors. However when I try to search for one rule I can't find it in the set of rules. When I try creating one of them manually it won't let me create it as it says it exists already, even though it doesn't show in the rule set. How can I undo what I did? How can I sort it out. A lot of people are depending of these rule set as it helps with Data extraction. Please support.

Best answer by IrinaDragusanu

Hi Chul,

Thanks for your reply. The above suggestion didn't work. The background is:

I have loaded a mass trx file to load some transformational rules. I imagine my beginner trx file was broken. It loaded the rules in the background but not showing in the Rules set. We were able to find the imported rules in the Application Database Tables. So we used the Rules IDs to delete them with a custom BR rule. However it is not recommended to use this type of BR rule that deletes the rule IDs from the Data Tables, as it can mess up the system if something goes wrong. Hope it helps.

2 replies

C
chul
May 6, 2025

I suggest extracting the existing Rule Group via trx, update that with your adds/changes using a text editor (NOT Excel), then upload it.

I
IrinaDragusanuAuthorAnswer
June 10, 2025

Hi Chul,

Thanks for your reply. The above suggestion didn't work. The background is:

I have loaded a mass trx file to load some transformational rules. I imagine my beginner trx file was broken. It loaded the rules in the background but not showing in the Rules set. We were able to find the imported rules in the Application Database Tables. So we used the Rules IDs to delete them with a custom BR rule. However it is not recommended to use this type of BR rule that deletes the rule IDs from the Data Tables, as it can mess up the system if something goes wrong. Hope it helps.

D
DanielWillis
Employee
June 10, 2025

Any idea what caused it? Anything funny about the rule?

I
IrinaDragusanuAuthor
June 11, 2025

My guess is that there could have been something wrong with the template loaded with the rules. I've created it from scratch so I might have missed a coma or something else. 

Terms & ConditionsAccessibility statement