Group by specific row

Hi @CKlinske , the way I’d approach this as follows…

First off use the rule engine to create a new column and into it place the value of column2, if column1=“GameID”, and leave it as missing otherwise.

This would give you the following
GameID, 1234, 1234
event, 111, ?
event, 222, ?
event, 333, ?
GameID, 1235, 1235
event, 444, ?
event, 555 ?

After that you can use a Missing Value node and have it set missing values on column3 to previous value, thus copying down the GameID to each event. I think that should work.

GameID, 1234, 1234
event, 111, 1234
event, 222, 1234
event, 333, 1234
GameID, 1235, 1235
event, 444, 1235
event, 555, 1235

This then tells you which events belong to each GameID. After that you can do Group By or whatever else you want to do with it

3 Likes