Multirow formula

KNIME Analytics Platform
#1

Hello,

I have one column with 0 and 1 like this

Keep
1
1
1
1
1
0
1
1
1
1
1
0
1
1

I would like to put 0 for all value after the first 0.
After I want to keep only row with 1.

I’m new in knime before I use alteryx and I have one tools multirow formula for compare my line with the line before and the line after.

thanks
regards
kevin

#2

Hi Kevin,

Welcome to KNIME Community Forum!

Just to see if I got you right. Should desired output from above input be like this:
1
1
1
1
1

so after first zero all values should be zero and then you will only keep rows with 1 meaning first five rows or?

Additionally here is a topic where switch from Alteryx to KNIME was discussed: Considering switching to KNIME from Alteryx

Br,
Ivan

#3

thanks a lot I will check the link.

you understood my problem that I’m trying to solve.

For me I need to do it in 2 tools but maybe not

regards
kevin

#4

Hi @kvn0026

I created a workflow that identify the firtst row with a 0, and uses this row value to filter the table.
multirow_formula.knwf (19.6 KB)
multirow_formula
gr. Hans

3 Likes
#5

it’s working

thank’s a lot

2 Likes
#6

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