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"
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.
I would add that after writing it to another dataset, you can request for those rows to be deleted via Domo Support.
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
