Hello All,
I have a dataset that looks similar to below:-
ZID | Product | Assessment | Round | Status |
34 | A | Packaging | 1 | Pending |
36 | A | Sterilization | 2 | Pending |
23 | A | Packaging | 1 | Complete |
56 | A | Packaging | 3 | Pending |
73 | A | Packaging | 2 | Pending |
12 | A | Packaging | 1 | Pending |
43 | B | Sterilization | 2 | Complete |
67 | B | Sterilization | 2 | Complete |
89 | B | Sterilization | 2 | Complete |
5 | B | Cybersecurity | 1 | Pending |
75 | C | Cybersecurity | 2 | Pending |
578 | C | Cybersecurity | 3 | Complete |
If all the Status values for a specific Product, Assessment, and Round combination are 'Complete,' I want to set the 'Delete' field to 'Y' for that combination.
Desired output
ZID | Product | Assessment | Round | Status | Delete |
34 | A | Packaging | 1 | Pending | |
36 | A | Sterilization | 2 | Pending | |
23 | A | Packaging | 1 | Complete | |
56 | A | Packaging | 3 | Pending | |
73 | A | Packaging | 2 | Pending | |
12 | A | Packaging | 1 | Pending | |
43 | B | Sterilization | 2 | Complete | Y |
67 | B | Sterilization | 2 | Complete | Y |
89 | B | Sterilization | 2 | Complete | Y |
5 | B | Cybersecurity | 1 | Pending | |
75 | C | Cybersecurity | 2 | Pending | |
578 | C | Cybersecurity | 3 | Complete | Y |
Thanks !
Solved! Go to Solution.
Thank you @geraldo 🤗
Thank you @RSreeSurya for the explanation
Hi, @Vineet003
Another way for you :
The easy formula :
IIF(Contains([Concat_Status], 'Pending'), Null(), 'Y')
*******
If you get your want, please mark it as a solution for more share.
Hello @flying008
Salute to you !! you are very kind to put in so much effort to explain :)