I have a list, basically containing an ID and a value column, e.g.:
ID_input____Value
1X________12
2Y________10
3Y________20
…
The IDs were transformed to another type of IDs, this gives me:
ID____ID_input
PUZ__1X
PAZ__2Y,3Y
The new list contains the type of IDs I need for further processing the data, but of course I would like to retrieve the values from the initial list. Using for instance the joiner node - full outer join yields:
Then simply by using GroupBy node where grouping column should be ID and aggregation columns are ID_Input with concatenate aggregation and Value with sum aggregation.