Summarizing results to pass/fail for a group.

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.

Screen Shot 2023-04-10 at 9.46.08 PM

Please let me know how I can best achieve this.

Hi @johnsonjm1992
As simply as this:
The outcome is
Please find the workflow attached.
Happy KNIMEing,
Fail_row_filter.knwf (13.9 KB)


Hi @johnsonjm1992

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

gr. Hans


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