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!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Compare list of values

The_Alternator
6 - Meteoroid

I'm looking to compare a list of values by there prefixes. So the data is simple, it looks like:

 

id | order_no

A | B6DKG

A | B6DKG

B | C2D63

B | C4D92

 

So I want to, for each id, check the order numbers by their two-digit prefix (B6, C2, C4). If the prefixes match under one id, then do nothing. If they are different, assign a field that says "multiple" for those records. Thank you.

2 REPLIES 2
Luke_C
17 - Castor

Hi @The_Alternator 

 

Here's one approach using the summarize tool to count the distinct prefixes and flag the IDs with multiple:

 

Luke_C_0-1617035058105.png

 

AngelosPachis
16 - Nebula

Hi @The_Alternator ,

 

Assuming that your input looks something like this 

 

AngelosPachis_0-1617035335401.png

 

you can using the following workflow to create that flag of multiples by counting the different prefixes appearing with a summarize tool

 

AngelosPachis_1-1617035370658.png

 

 

Hope that helps,

 

Angelos

Labels