Joe_Pitcher

Discussions

Any tips on how to clean Typo's in a dataset?
Hi all, I have a large and growing dataset with a number of human error typo's within the source. I am looking for a simple formula I can add to my ETL (or other method) to clean and fix common errors. An example to illustrate the issue, in my dataset I may have a field called 'Company Name' and within that field, for the…
Appending new data to an existing dataset
Hi all, hoping for some basic help and advice here. I manage a Domo dashboard, powered by a single dataset which is updated each month. Each month I am adding approximately 4,000 lines of data over 41 columns. What I am trying to achieve is the ability to add data, clean it via Magic ETL and save to the same original…