-
String Operation Add Space to Postal Code
Hi All, I cannot seem to find out how to add a space to a Postal Code Column using new Magic ETL. Trying to change a text string eg: S4L1A5 to S4L 1A5. thx!
-
CRM Sales Formula Help
Hi, I need help in creating a formula to write referral data to a new column. In the Dataset we have Columns A:C and I need to create a new Column D (Referred By) based on this logic: Where there are common engagement ID's (In this case 1234 or 5678) if 'inherited Sale' = True then set Referred By to Full Name. Thank you…
-
Adding Space to Postal Code TEXT String in Magic ETL
Hi, I might be missing something but looking for some help to add a space to a postal code text string using Magic ETL. I am trying to change a postal code from S4L1A5 to S4L 1A5. thx!
-
HTML Table Hyperlink Beast Mode
Hi, I am trying to find a way to add a hyperlink to my HTML Table where I have a Column called 'ID' with rows of numeric values of our Helpdesk Case #'s. How do I create a beast mode formula to link to our helpdesk system: If ID = 12345 and link is https://www.helpdesksystem.com/userui/ticket?ID=12345 Thank you in advance!
-
Magic ETL 1.0 rename Output Dataset
Hi, I am working on a dataflow to take an input dataset and write an output CSV file based on another vendor naming convention. Is there a way that I can automatically name the output dataset in this format? Example: Output dataset = CU_CSV_FILE_YYYYMMDD.csv so for today it would be CU_CSV_FILE_20210423.csv. thx!