Workflow output to provide unique entries each run & End-of-day count with total runs

[EmilDem01]

We execute the workflow three times: at 9:00 AM, 1:00 PM, and 5:00 PM.
1) Each run's output must include new HeadOffice IDs OR Purchase Order IDs.
2) The end-of-day workflow should reflect a count of unique IDs for the entire day, ensuring no duplicates.
How to i achieve this goal

Output at 9:00AM
HeadOffice ID	PurchaseOrder ID	Brand	Location	Comments	Purchase Method	Representative Name	Store Name	Type	Payment
4158963321	85236977	Nike	Oxford
4258963324	87412369	Nike	Kent
TRA1257891	82937191	Nike	Oxford

Input at 1:00PM
HeadOffice ID	PurchaseOrder ID	Brand	Location	Comments	Purchase Method	Representative Name	Store Name	Type	Payment
4158963321	85236977	Nike	Oxford
4963852111	89787891	Nike	Kent
TRA1257891	82937191	Nike	Oxford
Output at 1:00PM
HeadOffice ID	PurchaseOrder ID	Brand	Location	Comments	Purchase Method	Representative Name	Store Name	Type	Payment
4963852111	89787891	Nike	Kent

Input at 5:00PM
HeadOffice ID	PurchaseOrder ID	Brand	Location	Comments	Purchase Method	Representative Name	Store Name	Type	Payment
41589789451	85231111	Nike	Brent
4963852111	89787891	Nike	Kent
TRA96325871	82939633	Nike	Oxford
Output at 1:00PM
HeadOffice ID	PurchaseOrder ID	Brand	Location	Comments	Purchase Method	Representative Name	Store Name	Type	Payment
41589789451	85231111	Nike	Brent
TRA96325871	82939633	Nike	Oxford

End of Day - Count Check
HeadOffice ID	PurchaseOrder ID	Brand	Location	Comments	Purchase Method	Representative Name	Store Name	Type	Payment
4158963321	85236977	Nike	Oxford
4258963324	87412369	Nike	Kent
TRA1257891	82937191	Nike	Oxford
4963852111	89787891	Nike	Kent
41589789451	85231111	Nike	Brent
TRA96325871	82939633	Nike	Oxford

[griffinwelsh]

This is one possible solution:

1. Store the output from each run in a single folder as separate workbooks. You can append a timestamp to the filename to keep them separate

2. Your end of day workflow should start with a directory tool pointed to your folder

3. Use a filter to eliminate files from previous days

4. Use a dynamic input to read in data from all relevant files

5. Use a unique tools to eliminate duplicate rows

6. Output your expected output.

[EmilDem01]

Thank you 

[AndrewDMerrill]

@EmilDem01If your problem has been resolved, please kindly mark @griffinwelsh 's clear and concise response as the solution so that other's can more easily find answers to their questions.

Happy Solving!