This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.