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 |
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.
Thank you
@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!