Check all columns

[pruthvi1286]

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	?

[izaychik63]

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

[pruthvi1286]

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

[izaychik63]

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

[pruthvi1286]

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

[ipazin]

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

[pruthvi1286]

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.

[ipazin]

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

Br,
Ivan