We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Schema not matching

Vyx
7 - Meteor

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.

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

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

Labels