Hello,
I currently have a table in Knime that looks like the image I’ve attached. I need to end up with a table that has each customer’s purchased items represented as individual columns with yes and no(s).
This is a mock up I made in excel that I need it to look like.
Does anyone have any advise?
Hi @CMR
Welcome to KNIME Forum
Some advise from my side. Use the one to many node:
then you end up with O and 1. Next step is to convert 0/1 => no/yes.
gr. Hans
Hello @HansS ,
When i tried that the issue that, I had an issue where each of my customers’ purchased items were not grouped.
Like in this picture, Customer 1’s purchases are split up but I need them in one row.
Hi @CMR
Ok, I see. Go for the GroupBy node. Where Groups=CUST_ID, and Aggregation on your “food columns” . Aggregate methode = Max (or Sum should give the same answer).
gr. Hans
