I am trying to input multiple excel files using an input path that is "folder name"\*.xlsx and am getting the schema error attached. All of the files only have one sheet named "Sheet1". Attached are a sample of the files I am trying to upload.
Solved! Go to Solution.
These four files that you attached to the question get read fine in my designer
Hi @vandecx17 ,
This is happening due to a different format in a specific column. Since some columns are blank, it is reading as text where it should be a number.
I suggest you to lock all the columns as text and change to number in Alteryx.
Best,
Fernando V.
Hi @vandecx17, looking at the screenshot in the word doc., it looks you are pulling in the file B_2_0_Rates_2020_Feb.xlsx which has the tab 'b20 MASTER' which I am guessing has a different data structure than the other 4 files you shared with us.
Typically if one is looking to read multiple files from a given folder using the normal input tool, Alteryx assumes all files being read have the same structure. But in the event you have different structures across files, you could create a macro and select the option from View>>Interface Designer Tools>> Select the Option shown in the image below:
I have also attached a sample solution for your ready reference. Please mark this post as solution accepted if it answers your question.
Thank you, Fernando! How would I lock all the columns as text and change to number in Alteryx?