Cross Reference/Unique Identifier across dynamic records

Question

I have a fun/weird conundrum. I am attaching sample data for reference. There are many other columns in the actual files but i want to see if a solution can be found using the columns i will have available in daily files.

After reconciling two sets of data and also running previous day and current day results, we will have two group ids and what the reconciled status of them was previous day and current day.

How can I create an unique identifier to identify both the previous day and current day data? Is it possible to somehow pull it again for next day results if need be?

I tried the Unique value in Tile tool and it worked but i am hitting a wall as to how to re-use/repurpose that id again for next day. Any ideas? Thanks in advance

Test Data.xlsx

Yoshiro_Fujimori · Accepted Answer

@sowjanyayinti ,

To uniquely identify a row, you need to define a unique key.

And you want to identify the previous day data and the current day data separately.

So you need to split the two data to separate rows.

Here is a sample workflow to assign unique IDs to each row after splitting the rows.

I hope this helps.

Workflow

Formula Tool

Name =

IF [Name] = "Prev Recon" 
  THEN ToString([RecordID]) + ".Prev"  // You can set the ID names as you like.
  ELSE ToString([RecordID]) + ".Curr" 
  ENDIF

Output

IDGroup1Group2Value1.PrevAVN1234AVN1234Not Reconciled1.CurrAVN1234AVN1234Reconciled2.PrevAVN1234AVN1234 2.CurrAVN1234AVN1234Reconciled...