user17774

Works perfectly! Thanks so much for your help!

Thanks so much for your detailed explanation, it really helped!

Just to clarify, I'm not looking for advice on how to learn SQL but how to integrate it into a Beast Mode.?

Thanks for your help, I really appreciate it! You made me realize that I was approaching this in the wrong way and I know you weren’t being “snarky” ?! I totally get what you’re saying about SQL but I’m finding it hard understanding how to integrate it into a Beast Mode. E.g. According to the Beast Mode Functions Reference…

That's awesome! Thanks Superman!

Thanks for your response! I couldn't find a way to do this with an ETL because I have several customers with the same name but different site ID. I only want to change the name when both the site ID and name matches what I'm looking for. I can do this in both an ETL and a Beast mode but only by adding a new column. Thx…