Hello, KNIME Community,
I was wondering if I could get some help.
This is the output of my previous node. It relates to individual assessments for patients on particular days.
|ID |Date |A|B|C|D|E|F|G|H|I|J|K|L|M|
|87973|2022-12-20|?|?|?|?|?|?|?|?|?|?|?|?|0|
|87982|2022-12-23|?|?|?|?|?|?|?|?|?|?|?|?|1|
|87982|2022-12-28|?|?|?|?|0|?|?|?|?|?|?|?|?|
|87982|2022-12-28|?|?|?|?|?|?|?|?|?|?|?|?|1|
|87982|2022-12-29|?|?|?|?|0|?|?|?|?|?|?|?|?|
|87982|2022-12-29|?|?|?|?|?|?|?|?|?|?|?|?|0|
|87982|2022-12-30|?|?|?|?|0|?|?|?|?|?|?|?|?|
|87994|2023-01-04|?|?|?|?|?|?|?|?|?|?|?|?|0|
I want to merge the rows so that each ID and Date have a single row with the same A-M columns and name columns. So the output should look like this:
|ID |Date |A|B|C|D|E|F|G|H|I|J|K|L|M|
|87973|2022-12-20|?|?|?|?|?|?|?|?|?|?|?|?|0|
|87982|2022-12-23|?|?|?|?|?|?|?|?|?|?|?|?|1|
|87982|2022-12-28|?|?|?|?|0|?|?|?|?|?|?|?|1|
|87982|2022-12-29|?|?|?|?|0|?|?|?|?|?|?|?|0|
|87982|2022-12-30|?|?|?|?|0|?|?|?|?|?|?|?|?|
|87994|2023-01-04|?|?|?|?|?|?|?|?|?|?|?|?|0|
I think that I have a convoluted way of doing this but I’m after a simple answer.
Once again, thanks to all you who apply your brains to this problem. I remain grateful for this and all the past work.
A