handle row based on value in first field - kind of hierarchical

[mlauber71]

@Adrian73 welcome to the KNIME forum. Since I am on a mobile device I could not have a look at the solution by @victor_palacios. But it seems your example and the resulting data might not be fully consistent.

There have been similar data preparation tasks in the pastel you might want to take a look. And if you do not have a solution yet maybe amend your sample data.

Rearrange csv columns and rows

@jorgemartcaam OK … I put something together that would try to get your results but I have to warn you: it ain’t pretty and the CSV (?) format is as strange as it can be. I had to make a lot of assumptions and clear data based on your result and I must admit: seldom have I seen a stranger ‘format’. If at all you might consider going back to the source and asking for a better format. But alas: it can be done with KNIME … [image] I try to illustrate some of the things I found: [image] Some…

parsing hierarchical data

@dvkumaraws2019 I gave it a try and hope I have covered all cases you mentioned. [image]