Dev Space

Customize & extend the power of Alteryx. 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
20 - Arcturus

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