Check all columns

Hello All,
From the given table , I want to filter those rows where the missing values in a row or 2 or less than two.
for ex: row u, contains 3 values (in a1,a3,a4) and only two missing values( at a2,a5).
row t also contains only 2 missing values.
Hence I want a filtered table with only rows t and u.

Please help me with this. @ScottF
Thanks in advance.

value a1 a2 a3 a4 a5
q 126 ? ? 448 ?
w ? ? ? 94 ?
e 3632 ? ? 3632 ?
r 10 ? ? ? ?
t 7 ? 7 ? 11
y 338 ? 338 ? ?
u 51 ? 51 14 ?

The output Table is as follows:

OUTPUT :
value a1 a2 a3 a4 a5
t 7 ? 7 ? 11
u 51 ? 51 14 ?

Use Column Aggregator with Missing values count function. Then filter rows with counts greater then 2.

1 Like

Thanks @izaychik63
It worked. I was wondering if we can convert a flow variable to a workflow variable. I have a variable filtered based on a condition and now i want to pass that variable to multiple places as flow variables. So i was wondering if we can convert it into workflow variable for better access?
Thanks in advance

Look here
https://www.knime.com/knime-introductory-course/chapter7/section1

Thanks @izaychik63

I was wondering if i can select a node based on the input. Like if input is a then i want to one node to get executed and if input is b then i want another node to get executed. You think there is a way for me to achieve this?
Thanks in advance

Hi there @pruthvi1286,

You can achieve this with KNIME nodes for switching. There are If Switch and Case Switch nodes.

Here are workflow examples:
https://hub.knime.com/knime/workflows/Examples/06_Control_Structures/05_Switches/02_Using_a_If_Switch*HX6X19wFZ41e0Ri9

https://hub.knime.com/knime/workflows/Examples/06_Control_Structures/05_Switches/01_Case_Switch*_cHGyAPEClgQNXC3

Br,
Ivan

Thanks for the reply @ipazin

is there any way i can create dependencies between workflows ?
like i want to execute wf2 after the wf1 has executed The wf2 should be automatically kicked off when the wf1 completes execution as I run the wf1 from the server I want this process to happen.
Thanks.

Hi there,

can you please open a new topic for this question as it is not really related to subject anymore?

Also if you are talking about KNIME Server put it in KNIME Server category :wink:

Br,
Ivan

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