Adding a "Batch Number" Record ID to Duplicate Rows

[alexnajm]

Hi all!

I am curious if there is a solution for this problem: I would like to have a "batch number" added to all rows that match one another across the selected fields. For example, based on the fields selected or not selected, a column would be created with a grouping of sorts.

In this case, all 5 fields would be selected so the output would include the bolded column.

First Name	Last Name	City	State	Zip	Batch Number
Alex	Smith	Arlington	VA	22207	1
Alex	Smith	Arlington	VA	22207	1
Billy	Smith	Washington	DC	20008	2
Elizabeth	Smith	Washington	DC	20008	3
Jenifer	Smith	Bethesda	MD	20817	4

In this other case, only City, State, and Zip would be selected so the output would include the bolded column.

First Name	Last Name	City	State	Zip	Batch Number
Alex	Smith	Arlington	VA	22207	1
Alex	Smith	Arlington	VA	22207	1
Billy	Smith	Washington	DC	20008	2
Elizabeth	Smith	Washington	DC	20008	2
Jenifer	Smith	Bethesda	MD	20817	3

Ideally it may also add an additional column that indicates if the record is a "Duplicate" or "Not a Duplicate", but I figure I could work through that once the batch number is in place. Let me know if I can clarify the ask in any way. Thank you very much, and have a great day!

[alexnajm · Accepted solution]

Never mind, I found the answer... the Tile tool! 🙂

[vizAlter · Accepted solution]

Hi @alexnajm — Try this solution: