Hello, I’m new in Knime and I need some help.
I have a table with orders and products sets that ordered in each one and I need to find which is the percentage of appearence of each one product item for the total number of orders.
for example:
ORDERS ITEMS
1 x,y,z
2 x
3 y
4 z,y,h
5 x,y,h
I need to have this:
ITEMS PERCENTAGE
x 60%
y 80%
z 40%
h 40%
Is there any idea?
Thank you in advance