how can Knime subgroup data based on a column value

i have dataset that i want to apply classification and decision tree modelling. I have started out with the first list which is as follows

I have built the first classification based on the entry_filter using row filters.
how can i let the tool build the grouping automatically using the entry_filter column instead of buildin 4 different row filters?

Your data isn’t clear. Where’s the “entry_filter column” ? If its not proprietary, it would be helpful if you could share your data and give a more detailed description of the desired output.

I made a typo earlier. The layout of the spreadsheet is as follows

I want to classify the rows into separe nodes based on entry pattern. i created it manually using row filter and hard coding the pattern string.
Today, there are 4 possibile category but this list can expand
Ul49iDx1

I am hoping that there is a better way to do it

The output you want is a separate table for each entry_pattern with the associated exit_names?

exactly. i have done it manually with 4 filter rows but i am hoping there is a better way

Without knowing what your downstream processing looks like, its difficult to make any solid suggestions. The only way I can think of to avoid multiple row filters is to use a loop with a GroupBy node grouping by the entry_pattern and creating a list of the exit-names then ungroup inside the loop. The problem is what to do with the individual entry_pattern groups. You could either process them inside the loop or write them to files to be retrieved later. In either case it might be easier to use multiple row filters even if it doesn’t seem very elegant. Again without knowing your bigger picture I’m at something of a loss. I’m working on a loop approach which writes the individual entry_pattern groups to files.

@Suresh_Murthy an instrument could indeed be a loop. But as @rfeigel has said it is difficult to know without a concept of what it is you want to do and what the role of the input and exit pattern is.

This may give you some ideas. I’m sure you’ll need to adapt it to your situation.

2 Likes

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