Hi, I am having some challenges parsing hierarchical data into a tabular format. The raw data are stored as a “grouped” format as below. [image] This grouped hierarchical data needs to be transformed as below - [image] I tried to use a row filter, but only I could get particular rows. The excel is attached to this forum for reference. to_share.xlsx (10.2 KB) Since the data are in columns and its is stored in a series, I am having issues extracting them as “sets” of data and changing to tabular data form.

@dvkumaraws2019 I gave it a try and hope I have covered all cases you mentioned. [image] [image] extract hierachical data in special format – mlauber71 extract hierachical data in special format

parsing hierarchical data

KNIME Analytics Platform

mlauber71 February 19, 2022, 4:04pm 4

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

3 Likes

Move head rows to a column

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

File Reader (Complex format) problem