MarkSnodgrass Coach 
-
Re: COUNT(DISTINCT CASE WHEN THEN)
You are missing an END statement for your CASE statement COUNT(DISTINCT CASE WHEN `Account.Status__c` LIKE 'Cancel%' THEN 'Canceled' END)1 -
Re: Deduplicating a table based on the content of certain columns
The easiest way to do this is to use the Group By tile in Magic ETL. Add all your columns in the select except for the last_updated column. Add that one to the aggregated column list and choose Max. …2 -
Re: Replace an excel file uploaded using File Upload Legacy connector
If you go to the dataset in the data center and click on it, you can then go to the settings tab and re-upload a file.2 -
Re: Dynamic Target Based on Current Date
Your beast mode syntax should look something like this: (CASE WHEN CURRENT_DATE() >= '1/1/2022' AND CURRENT_DATE() <= '3/1/2022' THEN 98 WHEN CURRENT_DATE() >= '3/2/…2 -
Re: Moving one column under another
You can do this in Magic ETL with the Unpivot tile. If you are unfamiliar with it, you can read about it here: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#3.1
