3 questions on filters & components

[Jerome_G]

Hello all, hope you’re having a great day.

Picture for attention/understanding mostly:

Within my flow, I would like to:

1. Filter the data by

• Cluster (a group of country) and/or
• Country
• Date (year) and/or
• Date (quarter) and/or
• Date (month)

2. Some filter conditions above are interdependent (i.e. a Cluster will contain a set of countries)
3. Combine my filters and graphs in a component

I am trying to understand how “Nominal Row Filter Widget” works, however I am facing difficulties to:

• Combine in a component nodes that are in different “position” in the flow. Ideally I’d like to have my filter conditions on top and the result below.
  • In the image above I had the items in the blue box as a component, I tried adding the Widgets but it didn’t work.
  • I am also exporting the data as excel which is why I placed my filters before the pivot (excel export not shown in image)
• Manage interdependencies between filters. In my example, a Cluster will contain a set of countries and i’d like to avoid having to select both (one should feed the other). Likewise, if I select a year then I shouldn’t have to select the matching quarters or months.

For some reasons I haven’t figured out how the slider works (and many things in KNIME yet) so any help or pointers would be much appreciated.

[mwiegand]

Hi @Jerome_G,

that is a rather complex set of questions also because they all correlate to each other. Let’s try to answer one by one.

Data Clustering
Did you try to categorize the data by using any of the binner nodes

Auto-Binner

Numeric Binner

Binner (Dictionary)

You could also, incase you want to exert more control, use a Table and Value Lookup or Rule Engine instead.

Filter data
I suppose, based on the context, you want to do this dynamically in the interactive view. To accomplish this you need to use a GroupBy to create a set of values, pass this as aa variable to a filter node and map the variable. This must be done in a component.

Combine my filters and graphs in a component
Just select the nodes in question, right click and select Create Component.

If you’d share your workflow, providing aid would be more efficient.

Best
Mike

[mlauber71]

@mwiegand

To accomplish this you need to use a GroupBy to create a set of values, pass this as aa variable to a filter node and map the variable. This must be done in a component.

I have an example of such a dynamic filter on the KNIME hub

Dynamic Filter connected to several Python Views of a dashboard

@DanGenEire I tried to build something that should do what you want. It includes three Refresh Buttons. The component extracts all the numeric columns (for the chart) and all the strings (for the categories to select from) [image] The first button will refresh the list of options to filter from. In this case if you choose “cut” (of diamonds) it will provide you with the list of options where you can select the ones you want (one or several): [image] The chart will get updated and the sele…

Reference Column Filter with 'dynamic' reference table

@Kazimierz I have built a demo that would illustrate how such a system could work. The interface of the component would look like this: [image] you select the item the list of columns belonging to the item are dynamically selected the basic table is filtered by the Item and only the referenced columns are being selected When you press the Execute button the select would happen. And an Excel file with the data and the selected columns would be prepared. Also the results will be available fur…

[Jerome_G]

hi both,
thanks for the feedbacks, I will look into it.

Mike: No I did not use any Binner nodes, those are new to me, I will explore that.
I haven’t shared my worflow as I would need to extract the nodes and anonymise some notes, I didn’t do this when I raised the question.