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.
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.
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
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.
Thanks. I am looking at it now. I will let you know.
@MarqueeCrew Thank you kind sir! This works perfectly!
@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.
@binuacs Wow, this is simple and also works!