2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

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