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
Solved! Go to 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.
@spraveenkd
Here is a bit lengthy version. 😁
Thank you Luke. The logic seems to be simple.
Thank you Qui.the logic given by Luke is simple hence used it.