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.
Maybe there is an empty (hidden) column … try to select “Skip empty (hidden) columns” in the “More Options” section of the node configuration
If that is the message you got then they are probably not identical.
See this topic:
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.
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!
Glad you figured it out
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.