Dear Knime experts,
I am new to KNIME and I've set up my initial model for an automated csv to xls script which I need for my SAP protocolls.
The workflow should take all the files and convert each to a xls file:
The loop seems to work perfectly as I get different filenames in my folder (was done with String replacer) but each resulting xls helds the same data so it looks like file reader is not reading in "batch mode". Does anyone have a clue on it? I appreciate all answers.
unfortunately the dialog window of the file reader is not greyed out as it looks like in the xls-reader:
here the xls-writer:
It seems like the problem is the definition od the "Single Line comments", "read row IDs" and "Column Delimiter" as this leads to the usage of just the one file defined. when leaving this blank it iterates over the list of files.
But I need those parameters to correctly read the ascii. is there a possibility to define thes parameters in the "Flow variable" tab?!
It seems like the problem is the definition od the "Single Line comments", "read row IDs" and "Column Delimiter" as this leads to the usage of just the one file defined. when leaving this blank it iterates over the list of files.
But I need those parameters to correctly read the ascii. is there a possibility to define thes parameters in the "Flow variable" tab?!
I've cretaed some static variables in the workflow variable definition dialog but it keeps complaining:
Errors loading flow variables into node : Row delimiter must be defined as delimiter.
Would you mind uploading your workflow and some of the CSV files?
Best,
Marc