How to delete rows automatically based on a date in a dataset ?

user017486 · November 2020

I am inserting new rows in a dataset on daily basis, and now the dataset size has became huge since the rows are added daily. I want to delete the rows from this dataset based on date criteria (Dataset has a column type of "date" in it). So the criteria is like I want to maintain rows in dataset for last 30 days. eg assume I updated the dataset today (Nov 25) then dataset should only have rows (Oct 25 - Nov 25) and for tomorrow ie Nov 26 the dataset should have rows in range from (Oct 26 to Nov 26) and all the rows before Oct 26 should get deleted, if exist.

1. Is there a way I can do this?

2. Is there any API provided by DOMO that can be used to do programmatically?

GrantSmith · November 2020

Hi @user017486

I posted an answer to your question here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-to-delete-rows-automatically-based-on-a-date-in-a-dataset/m-p/51468/highlight/true#M9105

Next time you should only need to post your question in a single topic area as they're all well monitored.

How to delete rows automatically based on a date in a dataset ?

Comments

Categories