How to keep adding today's date to newly found records

Question

Need to add today's date to a list of record

Then when I run this daily, I want to check if the input has any other records that doesn't appear yesterday then add today's date and so on.

E.g.,

I run this on May 3rd

IDDate12345/3/202556785/3/2025910115/3/2025

I run this on the 4th and so on

IDDate12345/3/202556785/3/2025910115/3/2025143325/4/2025464425/4/2025

Is there a way to do this without producing an excel file? (or any output at all)

I want to append the new records I find to the list and keep adding today's date but only to the newly found IDs.

Hopefully this makes sense.

Thank you!

RJ_1988 · Accepted Answer

In that case, for the first run, you can simply output the records coming from the database  in an excel file, and that can act as a reference data for your future runs.

2nd  day onwards, you will have 2 inputs, 1st being the reference excel file and 2nd being the database. Perform a join and add  todays date to the delta, and keep on appending the reference master data. (Assuming that the data is not very huge, it that case you can create a Alteryx database file for your usage).

hal_dal · Accepted Answer

I ended up doing something similar but because I produce Tableau visuals after, I ended up using Tableau tools as my "output" and use the Tableau input tool to read the stored data (but logic wise, I ended up doing what you mentioned here)

Thanks!