Create a new table from existing table with data for last few days

user05966

Hi,

 

Let say I have a table that corresponds to a Domo card.

 

This table has a field with type 'Date'

 

Now I want to create another table that is exactly mirror to my 1st original table, but will consider data only for last x-days starting from my System-date. Furthermore, that new table should be updated automatically when my original table gets new data.

 

Is there any way to establish such process? If it is there, can you be explain how-to

NewsomSolutions

@user05966  I think this is what you'd need to do is create an ETL process.

 

In one lane of your ETL you could just do the work you are doing now...maybe it is select all columns...or you have something else you've already created. 

 

But in the second lane, you'd use the 'Date Operations' and do some calc like -5 days from current date...and filter on that value.

 

Then your ETL would look like this..

 

 

I hope this helps.

Matt

 

Please like to thank

NOAA2.JPG