@carllum26 i don’t think you will be able to just import this data with a CSV reader. You very likely will have to import the data as a whole line and then do some splits and joins.
The good news is that the data always seem to have the same structure so this should not be too complicated a task. I will see if I can come up with something.
It might be something like this
@Brotfahrer I had another look at the data and I would like to point you to another systematic approach. Using the underlying structure of the files to mark and split the relevant data.
the big blocks seem to be defined by parts marked ECU. With the help of row numbers, you can identify and mark these blocks as “Level1” value pair. You would have to deal with the header values separately and maybe add the file name as constant column.
The new LevelB is formed by Blocks that can be identified b…
Or this
@AAM i used your example and set up a workflow that hopefully takes you further in the right direction. Feel free to test it and ask additional questions.
I saw you used an advanced Column expression. I left that as it was.
In your case I would suggest to use a Loop and handle each message (consisting of several lines as one case and export that into a txt file). Therefor you would need a unique ID that would also server as a file name.
I like to use the KNIME protocol that makes it easy to p…
4 Likes