Excel Algorithm workflow help

Dear Knimers,

Please need your help in getting workflow

Input File:

From To 1 2 3 4 5 6 7 8 9 10
34 36 0 0 0 70 80 100 0 0 0 0
37 40 0 0 0 0 0 0 100 80 100 100
41 43 80 80 100 0 0 0 0 0 0 0
44 46 0 0 0 100 80 100 0 0 0 0
47 50 0 0 0 0 0 0 100 69 69 69

Output:

From To 1 2 3 4 5 6 7 8 9 10
30 40 0 0 0 70 80 100 100 80 100 100
41 50 80 80 100 100 80 100 100 69 69 69

Thanks in advance

Hi @Pragadeshgp
maybe this workflow can help you
KNIME_project5.knwf (11.1 KB)

1 Like

KNIME_project.knwf (4.9 KB)

I approached mine similar to @duristef using GroupBy, but without the need for a second table (although is certainly cost me a few more nodes). I have never messed with the Biner Dictionary Node before. That was a cool approach.

@iCFO The workflow you uploaded is incomplete, I’m afraid

Not sure what went wrong there… Of course I just closed it and was working in a temp file. I will rebuild it really quick using your table and re-upload…

@duristef Thanks a lot!
it worked

Forum Solution.knwf (18.1 KB)

Not sure why the first one failed to export, but here it is. Thanks for the heads up @duristef.

1 Like