Hello,
I’m using some oddly formatted data and was hoping for a little help. Essentially the data is set up as csv in this format:
GameID, 1234
event, 111
event, 222
event, 333
GameID, 1235
event, 444
event, 555
such that event 111-333 belongs to GameID 1234 and 444 & 555 belong to GameID 1235. What I’d like to be able to do is assign those GameIDs to a column that’s on each event. My first idea was to somehow use the JSON nodes to turn this into a hierarchy, but I can’t quite figure it out.
Thank You