Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.
SOLVED

Duplicate rows validation

AS
8 - Asteroid

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 

IDCodeComment
27409-B
27409-B
27409-B
27402-B
27404-B
27404-B
75509-A
15309-B
15304-B
15304-B
02109-A
27109-B
27109-B
75709-B
75702-B

 

Thanks in advance

 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @AS 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1628615722553.png

 

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 : )