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.
Solved! Go to Solution.
Here's one approach using the summarize tool to count the distinct prefixes and flag the IDs with multiple:
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