Lookup Transformational rule UNDO

Question

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.

IrinaDragusanu · Accepted Answer

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.

chul · Answer

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

Sign up

Login with SSO

Login to the OneStream Community

Login with SSO