I have a requirement as follows:
- Monitor folder where multiple files are placed each day. Only new files compared to last run need to be processed.
- Create a new input file based on file from step 1 and put in on file server
- Wait a couple hours to 1 day until a response file comes back that matches with the file in step 1
- Perform a comparison between file from step 1 and file retrieve through step 3. Highlight the differences and perform some more actions.
The difficulty here is that I need to keep track of when the different files where retrieve and I also need to match the 3 files from step 1, 2 and 3.
There are multiple ways to go about this tracking and matching. I believe keeping an excel is an option, but what would the UiPath go to practice look like? Would I need to use queues with custom fields to track and match the different files and steps?
Thanks for sharing your thoughts on how to best approach this.