Conditional Tableau Publish

Pradeep66

Hi team, 

I publish data from alteryx to tableau.

Here is my scenario.

dataset1: every morning, I create( overwrite the history yxdb file) this contains data from previous day to history.

dataset2 : this is something runs on the day every 20 minutes. (today data at 20 mins snapshot) my workflow runs every 20 mins.

I am overwriting this data to using publish to tableau server. ( because this is not append type data but snapshot level at dataset2.)

Requirement:

Every time I publish, is there a way to delete last 20 mins data deletion and append only latest 20 mins data to tableau server?

simply to put, delete old snapshot of today data from whole data of published data source and append latest via tableau publish to server.

this would save rewrite(overwrite of old data) time?

ArtApa

Hi @Pradeep66 - You would need to add a column with a time stamp to filter out 20 min. There are two ways to do that:

1) Date Time Now tool - In this case the tool will generate a Time Stamp at the beginning of your workflow run and you will need to Append Field to your dataset. All records will have the same time stamp.

2)  DateTimeNow() function in a Formula tool - In this case time stamps will be generated for every record separately.