Compare list of values

[The_Alternator]

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.

[Luke_C · Accepted solution]

Hi @The_Alternator 

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

[AngelosPachis]

Hi @The_Alternator ,

Assuming that your input looks something like this 

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

Hope that helps,

Angelos