How to read multiple files using Sharepoint Input Tool? I've been struggling with using Sharepoint Input tool. There are so many limitations with this tool. I'd appreciate any input/advice to improve the performance for any of these problems.
- It only accepts three file formats (xlsx, csv, yxdb). I'm unable to read xlsm, zip files using this tool. Is there any alternative solution like using Python etc?
- I'm bound to use Sharepoint tool and not directory tool since there is no Folder path location to the Sharepoint location? If so how to obtain folder path location to Sharepoint? Do I need to contact someone at my organization to setup a One drive path for Sharepoint?
- Sharepoint tool is very slow - Whenever I click the tool it takes 10 seconds to load. I'm using the parent folder as the main to obtain folder paths to all the *.xlsx files within the subfolders of the parent folder. Then using a simple macro to read the xlsx files and append. How to improve the performance of the Sharepoint input tool?
- I want to be able to deploy this solution to Alteryx server and schedule as jobs eventually.
