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

hamza_123
hamza_123 🟠
in Magic ETL

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

  • Jarvis
    Jarvis

    domo

    💎

    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.

Categories