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

Hi @The_Alternator 

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

New Workflow3.yxmd