Summarizing results to pass/fail for a group.

[johnsonjm1992]

Hi there,

I am having a bit of a mental block. I am able to perform the following process in Python but need to do using “pure knime” and I am having some trouble.

So I am looking through a file line by line and values have been assigned depending on if the line passes or fails.

As you can see, there is one “fail” in the pass_fail column. Based on that one condition, the entire December_1.xlsx file needs to be reported as “fail” as shown in the image below.

Please let me know how I can best achieve this.

[Kazimierz]

Hi @johnsonjm1992
As simply as this:

The outcome is

Please find the workflow attached.
Happy KNIMEing,
Kaz
Fail_row_filter.knwf (13.9 KB)

[HansS]

Hi @johnsonjm1992

Another option is to do an GroupBy on the filename and take the Minimum value of Pass_Fail.

gr. Hans