looping through XLS files

[callamari]

Hi, I have several .xls files that have column “product ID” and other columns. I am trying to create a list of all of the product numbers from all of the different .xls files. I’ve used:

list files -> table row to variable loop start -> excel reader (XLS)

I have an error “Execute fail: table created from file “B.xls” has different structure than previously read file”. How can I fix this? The 2 files are structurally identical.

[andrejz]

Maybe there is an empty (hidden) column … try to select “Skip empty (hidden) columns” in the “More Options” section of the node configuration

[ipazin]

Hi there @callamari,

If that is the message you got then they are probably not identical.

See this topic:

Combine multiple excel files but only the first 5 rows.

I have a workflow that will combine multiple excel files into one file and that works as designed. [combine multiple excel files] When I changed the workflow using the excel reader by Unchecking Read the entire the data sheet then adding Reading columns A to J and Rows 1 through 5 to create a sample workflow. When I execute I get an error Execute Table: Table created from the GoffstownOneStop.xls has different structure than the previous read files. All 5 files have the exact same Column…

Additionally you can share your files if not confidential and someone will take a look.

Br,
Ivan

[callamari]

Thanks all!! I got it figured out. The files were identical as I duplicate them but changed the data. Turns out I needed to change the flow setting to URL instead of Local file system. Thanks all for helping!

[ipazin]

Glad you figured it out @callamari!
Br,
Ivan