categorize

hi guys,

İ have the data of the sales but i want to categorize the secteurs with the basket.

For exemple:
Command code:123123123
Basket:123,456,789
Dry food:123,456
Vegetabels:789

So i want to categorize the same basket with different secteurs for the costomers satisfation.İ want the output:
Commend code:123123123
Products:123,789 or Products:456,789
İf the product is the same secteur it doesnt matter whşch one are we piciking the target is to have the basket to have differents secteurs.İ try the task with the GROUP BY node but i thnk there is more

Hi @efenem

The logic you are trying to achieve is not very clear, probably also due to some important parts getting lost in translation.

Can you show how you have this data in KNIME, what your desired output is in table format and what logic should be applied?

2 Likes

Ekran görüntüsü 2024-07-23 090513

so i want to categorize the sectors.In my first task i try to find the best combiantion of the products but i see people are buying products like banana and apple at the same time and thats not suprisng.So i want to categorize the sector too.For a better research

@efenem If you are looking for some shopping basket analysis and optimization you could g thru these links

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.