Schema not matching

Vyx

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-or-a-Specific-Excel-Range/ta-p/398220

https://truecue.com/resources/blog/alteryx-how-to-import-multiple-excel-sheets-and-files-with-different-schemas-in-alteryx/

Thanks in advance Vyx.

atcodedog05

Hi @Vyx 

Try this articles 3rd method https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480 

Similar to your 2nd link this article has a sample workflow that you can plug in input and check.

Hope this helps : )

Batch Input (1).yxzp