Hi All,
I have a 2 part question:
1) I have multiple excel spreadsheets (xlsx format) that I am trying to pull into Alteryx using the directory and dynamic input tool however when I run the workflow it states they have different schema however all files are exactly the same - all data sets start on the 12th row and they all have the exact same columns and data types within those columns - any way to identify the specific column causing the issue - would it be the fact that the data starts on the 12th rown? The data is proprietary so am not allowed to upload I am afraid.
2) I have done some searching and it appears the only way round inputting multiple files with different schema is using a batch macro - any advice as I have never created a batch macro - I have found the below link but am yet to attempt to create it.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...
https://truecue.com/resources/blog/alteryx-how-to-import-multiple-excel-sheets-and-files-with-differ...
Thanks in advance Vyx.
