Identify and label string occurrences in data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello all. I am a long time reader and first time poster. I have a peculiar problem that I need help with.
I have a set of data containing 3 columns (dummy data here). The issue is that this data looks like duplicates
so I need a way to identify and incrementally label each occurrence of this data. This is important further in the process.
Columns A, B and C are what I have. Column D is what I want to add to this data. I have attached this dummy data.
Thanks
Jon
Solved! Go to Solution.
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I don't see away to edit my post but please disregard the last row. It was a typo. That occurrence id is supposed to be 2.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @jmarcuzb ,
I built a CReW macro for that purpose: https://community.alteryx.com/t5/Public-Community-Gallery/Grouped-Record-ID/ta-p/903356
It is a Grouped RecordID. Please try it out.
Cheers,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How does this look @jmarcuzb? The select/data cleanse tools are just to tidy up the sample provided - Multi-Row is the real focus here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. I am looking at it now. I will let you know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MarqueeCrew Thank you kind sir! This works perfectly!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DataNath The Grouped RecordID solution proposed above worked perfectly for my situation. I will also check out your solution for future options. I do this everyday so I'm sure I will run across a slightly different situation where I can leverage this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Wow, this is simple and also works!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
