Hi Team,
I want to read data from a specific sheet from multiple excel files in a folder. I did go through the below link in the forum, but no solution provided.
Below is the screen shot of the workflow and the sheet name highlighted in yellow from which i want to read the data.
Any assistance much appreciated.
Regards,
Pavan.
If the sheet name is fixed and always the same, you don’t need 2 loops, looping over the file would be enough and simply in the Excel Reader select “Raw Data” as sheet to read.
Hi there!
Why no luck? Error or something else?
Br,
Ivan
Hi Ivan,
After checking the log and careful examination, i found that at column 15 and 31, has datatype mismatch. Number(string) vs Number(Integer).
May i know how do we deal with this.
Regards,
Pavan.
Hi Pavan!
In one Excel file you read column 15 as a String and in other as a Number. Error comes from that. Same with column 31.
You can check you Excel files and make sure that those columns (15 and 31) are all same type - which would mean KNIME will read it in properly. Another option is to use Column Auto Type Cast node in loop which would convert your column to best type (and the right one!) under assumption you have string/integer values where they are supposed to be 
Br,
Ivan
Hi Ivan,
Your assumption is right, those columns has string/integer values. I do not have any control on that.
If i use Column Auto Type Cast node after excel reader node, i am not sure how does it impact the datatype mismatch issue (is it the right way of using the node in the loop) or am i missing something.
Regards,
Pavan.
Hi Pavan!
Using Loop End node means you are concatenating results and node is expected to have same specification (by default). You can change this by checking “Allow changing table specifications” in node configuration. This way node will not fail but not sure if you will get for you are looking for…
Br,
Ivan
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
