SOLVED
Assigning unique ID
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
NairutiPatel
6 - Meteoroid
‎08-11-2020
09:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am looking to assign a unique ID corresponding to unique 'cancer type' in the attached excel without loosing the duplicated rows of records. For example, all the 'Breast cancer' rows should have the same unique ID. Similarly, both the melanoma rows should have the same unique ID.
I can identify the unique rows using the 'Unique' function and assign ID to those using the 'Record ID' function but i loose the duplicated rows. How would i go about this in Alteryx desginer without loosing the duplicated rows?
Many thanks in advance,
Nairuti
Solved! Go to Solution.
2 REPLIES 2
Drussek
9 - Comet
‎08-11-2020
10:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Why not like this?
‎08-12-2020
09:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Drussek!
