sort the data according to the number of items topic:

KNIME Analytics Platform
,
1

hello everyone I need help with knime assignment. I am applying association rules to the dataset. in a dataset, I have only a number of transactions. I don’t know how to sort the data according to the number of items in each transaction (largest transactions first). I used the string manipulation node but i don’t know about the query. can anyone please help? I will be very thankful

2

Are you from the same institution?
see the link

1 Like
3

yeah i am studying in jonkoping university. i read this but stiill i am note able to solve

4

Hello @Sameen,

where are you failing to apply @izaychik63 suggestion? Did you manage to count number of commas and get that information in separate column?

Br,
Ivan

5

i dont konw how to apply the countchar(string, ‘,’) query in string manipulation node

6

Hello @Sameen,

you need to replace string with your column name. What might help are examples on the left when you click on function in String Manipulation node so check those out. Also here is video that can help you figure out how basic data manipulations work in KNIME:

Br,
Ivan

7

thank you so much, Ivan. now I manage to count the number of commas and get that information in a separate column. after that should I take the sorter node to sort the data

2 Likes
8

Hello @Sameen,

great. Yes, Sorter node should be next.

Good luck!

Br,
Ivan