Duplicate rows validation

[AS]

Hi Experts,

Could you please help me in a validation process. 

• If at ID the only 1---09 (Code) tag ..comment will be “A”
• If at ID there are more than 1--- and any of the line have 09 (Code) and tag comment will be “B”

Showing you the example below 

ID	Code	Comment
274	09-	B
274	09-	B
274	09-	B
274	02-	B
274	04-	B
274	04-	B
755	09-	A
153	09-	B
153	04-	B
153	04-	B
021	09-	A
271	09-	B
271	09-	B
757	09-	B
757	02-	B

Thanks in advance

[atcodedog05 · Accepted solution]

Hi @AS 

Here is how you can do it.

Workflow:

1. Using formula tool to create 09- flag column.

2. Using summarize groupby ID, count rows and 09- flag sum.

3. Using formula if row count > 1 and 09- flag sum > 0 then B else A

4. Using find and replace to map the comments to data.

Hope this helps : )