I am working on a work flow to read multiple files with varying row and columns. I have built the work flow as below but when it runs it just reads the initial file selected in the reader node over and over for as many files as listed in the list file node.
The file has multiple sheets but to configure the reader node I selected the largest file and selected the one sheet I want to read from from the files. Because of the varying rows and columns I selected the columns to read (E to BF) and the rows (4 to 5000).
Hi @KevinD1,
Can you give a screenshot of your Excel Reader Node. Configuration?
It sounds like you did not configure the file path though the flow variable
Thank you for the responses. I am now just able to work on this project again and wanted to send the follow up to see if you could assist.
Below is the image of the configuration window on the excel reader. I did not select anything on the Flow Variables tab. I also allowed variable column types and changing table specifications in the loop end.
I would assume it means that you have data formats other than -well- string, integer or doubles. Maybe you could check that out.
If you absolutely must save to a CSV you could try and convert the data to string.
Another option could be to use R and see if this can handle your formats. But you might have to transfer the data to R first thru a R node (which uses wither data.frame or data.table).
Thank you for the response. I was able to figure this one out. The qty in one column was showing as non-native to Knime. Simple solution to use String Manipulation node and convert column toInt(). CSV or Excel Writer recognized the column once executed.