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

[hal_dal]

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

ID	Date
1234	5/3/2025
5678	5/3/2025
91011	5/3/2025

I run this on the 4th and so on

ID	Date
1234	5/3/2025
5678	5/3/2025
91011	5/3/2025
14332	5/4/2025
46442	5/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!

[Yoshiro_Fujimori]

@hal_dal ,

If you can say something on the design of the input data,

it would be better to ask the designer to add the record creation date as soon as the record is added.

If you can just receive the data and you are responsible to add the date to the record, here is one solution.

I hope this helps.

Input data

Data from yesterday (you keep)

ID	Date
1234	2025-05-03
5678	2025-05-03
91011	2025-05-03

Data received today (from the source)

ID

1234

5678

91011

14332

46442

Workflow

Output

ID	Date
1234	2025-05-03
5678	2025-05-03
91011	2025-05-03
14332	2025-05-07
46442	2025-05-07

(To keep the order of the records, you need to use Engine Compatibility Mode.)

[hal_dal]

Thank you so much for your response!
The data will be coming from a database given to us, unfortunately that's a data managed by another team that we utilize so asking them add might not be an option :(

[RJ_1988 · Accepted solution]

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 solution]

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!