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

Question

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 IDPurchaseOrder IDBrandLocationCommentsPurchase MethodRepresentative NameStore NameTypePayment415896332185236977NikeOxford      425896332487412369NikeKent      TRA125789182937191NikeOxford

Input at 1:00PM        HeadOffice IDPurchaseOrder IDBrandLocationCommentsPurchase MethodRepresentative NameStore NameTypePayment415896332185236977NikeOxford      496385211189787891NikeKent      TRA125789182937191NikeOxford                Output at 1:00PM        HeadOffice IDPurchaseOrder IDBrandLocationCommentsPurchase MethodRepresentative NameStore NameTypePayment496385211189787891NikeKent

Input at 5:00PM        HeadOffice IDPurchaseOrder IDBrandLocationCommentsPurchase MethodRepresentative NameStore NameTypePayment4158978945185231111NikeBrent      496385211189787891NikeKent      TRA9632587182939633NikeOxford                Output at 1:00PM        HeadOffice IDPurchaseOrder IDBrandLocationCommentsPurchase MethodRepresentative NameStore NameTypePayment4158978945185231111NikeBrent      TRA9632587182939633NikeOxford

End of Day - Count Check        HeadOffice IDPurchaseOrder IDBrandLocationCommentsPurchase MethodRepresentative NameStore NameTypePayment415896332185236977NikeOxford      425896332487412369NikeKent      TRA125789182937191NikeOxford      496385211189787891NikeKent      4158978945185231111NikeBrent      TRA9632587182939633NikeOxford

Output_Customize.xlsx

CoG · Answer

@EmilAlteryx01If 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!

EmilAlteryx01 · Answer

Thank you

griffinwelsh · Answer

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.