Domo - delete data

Options
rishi_patel301
rishi_patel301 Member
in Magic ETL

Why does Domo not have a simple way to delete certain rows that match a criteria?


How can I delete certain rows from a dataset? Analogous to SQL "DELETE FROM"

Answers

  • GrantSmith
    GrantSmith Coach

    Because of how the underlying architecture of Domo and data storage in general it's not like a Database where you can just simply run a DELETE FROM type command.

    What you can do is do a dataflow to input your dataset, filter out the rows you don't want and then write it out to another dataset.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ArborRose
    ArborRose Coach

    Domo has a command line interface (CLI) which includes ways to do things like delete rows.

    https://domo-support.domo.com/s/article/360043437733?language=en_US

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories