Hi there,
Quick query. Suppose, I have of my purchase list like this:
BRAND A - soap - 3
BRAND B- soap - 4
BRAND C - soap - 9
BRAND D- sanitizer - 7
BRAND E- sanitizer- 6
How do I aggregate the totals based on soap and sanitizer 16 and 13 respectively using a KNIME node. Any simple solutions would be welcome.
This is just a sample example; Actually I have data running to 500+ items and I need to aggregate/groupby few family of items and calculate the stats for the same.
Thank You
|RAN100|Soap|1|
|RAN123|Soap|4|
|RAN145|Soap|5|
|RAN201|San|6|
|RAN203|San|4|
It would be helpful as to how to achieve this:
SUM of RAN1* =10
SUM of RAN2*=10
I would use a string manipulation node to trim the product IDs down to a stem consisting of the leftmost 4 letters, then use the GroupBy node to group by that stem.