Hi,
I am creating a wokflow where i need to deal with csv that are sent by email by clients. But it’s not always the same format. I have a loop with the node csv reader :
But my problem is that my csv files doesn’t have the same cells separators. If I press the autodetect format button it works but for the next iteration it might not. Is there not a way to automatically autodetect the format of my csv each time ?
Thanks for your help !
Elise
What column delimiters do you have?
worst case: use a line reader and process it afterwards (one loop reading, one transforming).
but I would likely prefer a different approach with either dedicated readers by type or some chained try nodes
@Elise_1 you could employ the KNIME Python extension to automatically detect the delimiters and import the file:
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
