Dear KNIMErs,
Does somebody know how I can aggregate on distinct cells using the GroupBy node (or in a different way)? The rows containing a particular cell value can only appear in the first group, after this, KNIME has to choose the first distinct cell, so the second one.
I have this dataset
Task - Date - Employee - combined string (date&employee)
1 - 4/1 - 12 - β4/1, 12β
1 - 5/1 - 13 - β5/1, 13β
1 - 6/1 - 14 - β6/1, 14β
2 - 4/1 - 12 - β4/1, 12β
2 - 5/1 - 13 - β5/1, 13β
2 - 6/1 - 14 - β6/1, 14β
Now I would like knime to choose the first available Employee, but when the combined string is already used it cannot be used again.
I used the GroupBy node to aggregate on the first combined string, but I got duplicates, of course.
I would be very happy if somebody could help me.
Thanks in advance!