unique id
1 Topic
Create unique ID from transaction number if no ID exists
I'm trying to migrate some manual customer data and having issues with blank Unique ID fields. Thanks in advance for any help on how to create this column Some of my rows have a unique ID and some don't. I need to allocate Unique IDs in a new column called UniqueID to all the rows but it's a bit complicated. Is it somehow possible to do the following in this order? If oldID is not blank and is unique, use oldID else if transactionNumber is not blank use transaction number + instance # of transaction (eg 3rd row containing 5555 will get the id 555503) else prefix the column with E and assign it an incremented unique number EG: oldID TransactionNumber Name UniqueID 11653 Alice 1165300 24 11654 Mark 24 11654 Kate 1165401 25 11655 Anne 25 6 11656 Peter 6 24 11657 Terence 1165701 11658 Andrew 1165800 11658 Toby 1165801 11658 Laura 1165802 Samantha E000001 Sarah E000002 Kate E000003Solved2KViews0likes3Comments