Check Condition By Group

[Vineet003]

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 !

[geraldo · Accepted solution]

@Vineet003 

An workflow example

[RSreeSurya]

Hi Vineet,

Attaching the workflow. 

Step 1:

I have created a column with the required combination, as shown below, and used Summarize to concatenate status. 

Step 2:

'Delete' column formula

Attaching sample Output below:

Hope this helps. 

[Vineet003]

Thank you @geraldo 🤗

[Vineet003]

Thank you @RSreeSurya  for the explanation

[flying008]

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.

[Vineet003]

Hello @flying008 

Salute to you !! you are very kind to put in so much effort to explain :)