Hello I’m still learning this tool, so apologize if this is a pretty easy question.
So I want to use a node that would be similar to a case when statement. I have a condition to see if a specific column contains the string Partner and if it does I want it to use t1.acct_id and if doesn’t then I want it to use t2.acct_id. It seems like the rule engine would be the best choice, but I’m having trouble implementing it.
The rule engine cointains a “LIKE” function, which you could use in cases where you don’t know 100% what the row value looks like, but contains the word partner.
For example: