I need to iterate over all excel files in a folder, and create a queue item for each row in each excel in Orchestrator.
What is the best structure? If my understanding is correct, I would:
- loop over each excel file in “Get Transaction Data”
- make each file name a transaction item in GetTransactioData.xaml
- kickoff process.xaml for each transaction, and each row would be added to queue in “Process.xaml”
Is this following best practices? Am I understanding how to use the framework correctly?