Looking for help moving sub-headers in a column into their own column

[kingsteved]

Hello, very new user, just downloaded version 4.7 on Windows. I’m looking to jump into a way to automate a workflow that I currently do manually in excel. Right now, I’m getting the very basic filtering and transformations but I’m struggling with this one. My biggest issue is I just don’t think I know the terminology of what to even google!

Let me just give a simple example and it might make more sense what I’m looking to do.

Here is essentially what I’m given:

UserID | UserName
GroupA |
1111 | Bob
2222 | Ellen
GoupB |
3333 | Greg
4444 | Garth
GoupC |
2222 | Ellen

What I’d like is:

UserID | UserName | Group
1111 | Bob | GroupA
2222 | Ellen | GroupA
3333 | Greg | GroupB
4444 | Garth | GroupB
2222 | Ellen | GroupC

[mlauber71]

@kingsteved welcome to the KNIME forum. You can do this by combining several nodes. You can identify the head off a block Group) and then the block by filling the musings. Next step would be a loop. Maybe a group loop to join the header to all your lines.

Maybe you can adapt this example

Move head rows to a column

@willy_oracle typically you would mark all lines with a Counter. Then identify the ‘headers’ with a rule engine [IF Col1 LIKE “Head*” => Counter] and keep that (starting) row in a separate column. Then you fill the missings with the previous value so a block would emerge marking the data table: [image] So now you have the blocks marked an can use a Table Row to Variable Loop Start – KNIME Community Hub or Group Loop Start – KNIME Community Hub to do something with the blocks (export them delet…

[kingsteved]

Thanks, that looks similar enough to get me started.

Cheers!

[Daniel_Weikert]

You could use Rule Engine Node to create a second column with only the “Group X”, then use missing value node with previous value to fill down and then (if necessary) combine columns with pipe symbol.
br