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...

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

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 : )

[Adarsh_R3]

Check out this macro

https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-All-Exc...