Magic ETL

Magic ETL

How to delete rows from an input dataset and replace the dataset

I have an input dataset, on which I want to perform an operation to highlight which records are obsolete, and then permanently delete those records from the input dataset. 

 

I was trying to use SQL transformations, but I cannot make the output dataset the same as the input dataset. Could someone help?

Comments

  • Domo Employee

    You're on the right track, but you're correct. Building a MYIt's going to make a new dataset output. You can then take that and plug it into any relevant workflow.

     

    If you're looking to remove specific entries from a historic append chain, there's another option. There's a hidden function on DOMO's dataset. If you add ?_f=dataRepair to the end of a dataset url, a new tab called Data Repair will pop up. In there, you can see all the uploaded data versions.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In