Implementing Daily Unique ID Tracking in Alteryx Workflows

[KamenRider]

Hello Alteryx Community,

I am working on a data processing task where I need to log new and unique numbers under the "No Story Execution Found" category. The goal is to identify and count occurrences of unique numbers that appear for the first time in my dataset. I am attaching the input file for your reference and below is the result.

 

The process involves comparing today's ID numbers with those from yesterday. If a new ID number appears today that was not present yesterday, it should be logged as a new entry under "No Story Execution Found" for today. The table above illustrates how each unique number is counted and logged based on its first occurrence. Note that there is no value logged for June 2, indicating no new unique numbers were found on that previous date. So if the date today 19 for example, ID numbers will be compared with June 18. If there is a new ID number, it will be log in June 19 else blank.

I do hope you can show me how it will be done dynamically.

Thanks and looking forward for your response.

Kamen

[PangHC]

@KamenRider since you are rank-11, I do not share any workflow here.
i believe you can do it.

1. compare to -1 date, but since it not a sequence, using Tile to number the date (unique value by date)

2. using left-anti join, to find out the new id, crosstab afterward

3. to form the fulldate table, use the date before join to create another crosstab to union it.

[KamenRider]

Hi @PangHC 

Can I ask for the workflow you sampled so  I can check how you do it. I notice Column A is missing.

Thanks,

Kamen

[KamenRider]

Hi @PangHC 

I also notice that the your result does not match with my result. I have only 1 new ID Number for June 16 and no value for June 13.

Please advise.

Thanks,

Kamen

[KamenRider]

Good day Alteryx Community,

any help?

Kamen

[PangHC]

@KamenRider 
column A is missing because it is a hardcode things. you can add manually (via formula tool) after the both crosstab tools

for 13 Jun an 16 Jun, it does value 1 and 2. base on your description, it just validate -1 day data.
where only "1534463715" appear in both -1 date.