Identify and label string occurrences in data

[jmarcuzb]

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

[jmarcuzb]

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.

[MarqueeCrew]

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

[DataNath]

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.

[jmarcuzb]

Thanks. I am looking at it now. I will let you know.

[binu_acs · Accepted solution]

@jmarcuzb you can also use the Tile tool 

[jmarcuzb · Accepted solution]

@MarqueeCrew Thank you kind sir! This works perfectly!

[jmarcuzb]

@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.

[jmarcuzb]

@binu_acs Wow, this is simple and also works!

[MarqueeCrew]

@jmarcuzb ,

I think that you wanted to mark both my post and @binu_acs as SOLUTIONS.