Hello Everyone!
My current situation involves receiving periodic data updates from multiple business units, each in different currencies. Currently, I manage the data workflow using Excel sheets.
However, with every update, I face the manual task of removing the old Excel sheet and uploading the new one. To streamline this process, I decided to explore using OneDrive.
I downloaded the OneDrive tool and replaced the Excel file with the OneDrive input tool, ensuring I selected the appropriate OneDrive Excel file accordingly. However, I encountered a few issues:
1- I'm unsure how to configure the output file name as a field using OneDrive. In Excel, it's easy as you can simply select it through the options.
2- Another concern is that I don't see the OneDrive info in the output result. It's essential to have this information for proper tracking and organization.
3- (not urgent) I noticed that the AMP engine must be running, but in some cases, I have more than 32 connections per currency. I attempted to break it down to two connections, which worked, but I'm open to discovering if there's a better process for handling this situation.
Thank you all for your help!
