Forum Discussion

Nipius's avatar
Nipius
Advocate I
7 years ago
Solved

Creating unique value if value already exists

Hi all!   I have a query including a column with duplicate values. For the purpose of my table, I'd like to add another column where I add another character (for example "A" or "1") to the duplicat...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Nipius here you go, see attached, I added two unique columns one with _1, _2, _3 and so on and other with _A, _AA, _AAA and so on.

parry2k's avatar
parry2k
Super User
7 years ago

Nipius if you share your full sample dataset it will help, I just gave you the solution based on what you posted originally.

Nipius's avatar
Nipius
Advocate I
7 years ago

parry2k : Sure! Herewith the link to the file. It's on my personal NAS, as my organization does not allow to create shareable OneDrive links for persons outside the organization.

 

I've added the Position_Unique column manually for your reference, but this is in the end the result I'd like to get. Hopefully this makes sense.