SOLVED
Using a unique tool
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
Feras95p
8 - Asteroid
‎11-04-2020
03:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear all,
I have a data in a multiple rows what I want is that, I want to get rid of the duplicated rows but to identify the duplicated row I don't want to use only one column in the unique tool. I want to check 3 to 4 columns and see if the same duplicated on the other rows then give me the unique row.
For example in the columns I have the Date, Customer ID, Mobile Phone, District Name
if all are unique or not, but if there is other one row with the same data of these columns get rid of it.
Any help how can I do that?
Solved! Go to Solution.
Labels:
- Labels:
- Help
- Join
- Predictive Analysis
- Udacity
- Workflow
2 REPLIES 2
Alteryx
‎11-04-2020
03:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Feras95p
You can use the Unique tool and check all fields to make sure duplicated rows (not only a specific field) are excluded
21 - Polaris
‎11-04-2020
03:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/AD878934BD3B103B7FE6F7E96BE02CD9/responsive_peak/images/icon_anonymous_message.png)