Pentaho check if at least one row LDAP is 0

I have multiple rows in Pentaho with Column name "LDAP flag"

I need rows like below:

If at least one row is 0 then I need to set "LDAP check" to True

If all rows equal 1 then I need to set "LDAP check" to False

As always in PDI, you can do this in various ways. This is just one of the ways to accomplished this.

You can use the Group by step:

• Mark the check to retrieve all rows instead of only the grouped rows
• You don't group by any row, so all the rows are involved in the sums and counts.
• You calculate two values with your grouping rows:
  • You sum the value of the column LDAP flag for all rows. I name this column SumFlag in my screenshot.
  • You count all rows. SumRows in my screenshot.
• You use a Formula step to calculate a new column (NewLDAPflag in my screenshot) with value 0 if SumFlag is 0 or is equal to SumRows, and value 1 in any other case.
• I haven't added it to my screenshot, but if you want as final result only two columns, the original Column and the LDAP flag with the new value, you can use the Select values step to select the columns you want and rename as needed.

This is the configuration of the Group by step:

And this of the Formula step: