SOLVED
Remove Dups
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Brad1
11 - Bolide
‎02-06-2019
05:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
If I have a field like this:
Acct Number States Doing Business in
12345 AK, AK, AL, MS, AK
s/b
Acct Number States Doing Business in
12345 AK, AL, MS
How do I get rid of the dups?
Thanks in advance for any help.
Solved! Go to Solution.
Labels:
- Labels:
- Output
- Parse
- Preparation
2 REPLIES 2
16 - Nebula
‎02-06-2019
05:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Brad1 Are you saying your data looks like this?
ACCT NUMBER | STATES DOING BUSINESS IN |
12345 | AK |
12345 | AK |
12345 | AL |
12345 | MS |
12345 | AK |
If so, you can just use a Summarize tool to GroupBy both fields. This will leave you with each unique combination of acct number and state.
‎02-06-2019
05:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Never mind. I just needed a Summary Tool first.
