Comments
-
I saw this as I was searching for a similar solution. Here is how I solved it. I create a Magic ETL dataset to keep this complexity away from my business users. Our Salesforce outputs converted $ amounts like: USD 12,500 I added a Replace Text Step to and ETL as: Column Find Replace Amount USD Empty String Amount , Empty…
