Group by implementation with condition

[spraveenkd]

The input data is from col1 till col4

The requirement is we have to do group by with col1 and col2 with all the values of col4 if PASS then PASS_FAIL is PASS else FAIL

[Luke_C · Accepted solution]

Hi @spraveenkd 

Here's one way. Use the summarize tool to group by col1 and get the minimum value of col4. Then join back to the data.

[Qiu]

@spraveenkd 
Here is a bit lengthy version. 😁

[spraveenkd]

Thank you Luke. The logic seems to be simple.

[spraveenkd]

Thank you Qui.the logic given by Luke is simple hence used it.