Excel Algorithm workflow help

[Pragadeshgp]

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

[duristef]

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

[iCFO]

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.

[duristef]

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

[iCFO]

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…

[Pragadeshgp]

@duristef Thanks a lot!
it worked

[iCFO]

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.