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

Exported N_Analysis.xlsx

AncientPandaman

@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.