Transformation Tips and Tricks
- Adding a Unique Key Column Using Magic ETL
- Adding and Subtracting Hours in the Old Magic ETL
- Aggregate vs. Non-Aggregate
- Archiving Historical Data Using a DataFlow
- Beginning and End of Week
- Creating a Rank or Row Count
- Creating a Recursive/Snapshot Old Magic ETL DataFlow
- Creating a Recursive/Snapshot SQL DataFlow
- Creating a Rolling Average Period-over-Period DataFlow
- Creating a Rolling Average Using DataFlows
- Data Cleaning Operations Using SQL and Magic ETL DataFlows
- DataFlow and DataFusion Troubleshooting and FAQs
- Date Difference for Business Days
- Dealing with Attribution Windows
- Dynamic Pivot
- Excel to Domo Matrix (EDM)
- Finding the Median of a Value
- Pulling a Segment of Text from a Text String
- Removing Invalid ASCII Characters from Your Data
- Removing White Space from Text Strings
- Showing the Distinct Count for a Column
- Using "Does Not Contain" in Magic ETL