How to delete data of a domo dataset
I have a domo dataset created from a source ( Teradata ) via some tool. That domo dataset having 4 weeks of data I found that one of the four weeks data is incorrect and would like to delete only that 4th week data. I checked all options in domo I did not find an easy to delete that week data.
FYI, I have admin access but, still not be able to delete data from a domo dataset. One thing what I checked is to create another data set from the eixsiting dataset and leave the week where dirty data was there. But, the week data is huge which is about 130 millons of rows. Now, creating one more or derived dataset itslef is redundant and occupying the space. Do we hava any interface in dom where in I can write a simple SQL statement as below
delete from domodataset1 where item=1234;
This way I can easily delete data.