Update/replace value according to the condition

[Rajakumaranakash]

Hi All,

I have 3 colums 'Server','ID' and 'In list'. The value of list is either 'Y' or 'N'. If at anytime the server is in the list i.e., 'Y' then all the related server rows of the list should be marked as 'Y'. Could someone help with the simplest solution for this. Please see below for sample and expected result:

Sample

Server	ID	In list
S6	500	Y
S1	121	Y
S2	123	N
S3	145	Y
S4	155	N
S5	189	N
S1	124	N
S1	155	N
S1	126	N
S2	114	N
S3	178	N
S7	197	N
S4	211	N

Desired Output:

Server	ID	In list	New List
S6	500	Y	Y
S1	121	Y	Y
S2	123	N	N
S3	145	Y	Y
S4	155	N	N
S5	189	N	N
S1	124	N	Y
S1	155	N	Y
S1	126	N	Y
S2	114	N	N
S3	178	N	Y
S7	197	N	N
S4	211	N	N

[Prometheus]

@RajakumaranakashI used the Summarize tool to group by Server and create a concatenated list of Y and N for each server. After that, I used a Formula tool with a conditional expression to replace any value in "Concat_In list" that contains "Y". Then I joined it back to the original data on Server=Server.