Create Record IDs based on 3 columns - for recon purposes

[PassION_es]

Hello Alteryx,

Requesting your assistance with assigning record ids based on the values in the 3 columns - date, bank account & amount.  I need to mark the record ids for each line item based on whether the values in these three fields are similar to another line item.

If the 1st and 2nd line item have the same values in the mentioned fields, then the record ids should be marked as 1 for the first line and 2 for the 2nd line.  However if a single line item is unique, and has no duplicate, then the record id should be 1.  Please refer to the attached sample.

Thank you in advance for your help.  

[binuacs · Accepted solution]

@PassION_es One way of doing this with the tile tool

[Raj · Accepted solution]

@PassION_es 
Another way of solving this

please mark as done if this is resolved.

[PassION_es · Accepted solution]

amazing! Thanks @binuacs & @Raj .