Forum Discussion
Is it possible to create a unique identifier based on the contents of two columns?
Would this not just be the same as duplicating your table, removing everything but the survey column, removing duplicates then adding an index column?
Memorable MemberThis is maybe if you've had some experience editing M code.
If you want to make a unique identifier on 3 existing columns, in Power Query Editor, you could click Add Collumn > Custom Column.
For the formula, you can add all the column names seperated by an ampersand (&) to concatenate. So, something like
[Column1] & [Column2] & [Column3]
Be aware that they have to be the same format (text, number etc).
I would also reccomend using a character to concatenate in the middle, I usually use a carrat (^). This can stop repeats, especially for numbers - for example, if you join 51 & 11 = 5111, and 5 & 111 = 5111.
So the code could be:
[Column1] & "^" & [Column2] & "^" & [Column3]
As you are concatenating text, all columns must be text.
You can either change them all the columns to text and combine, or if you have numbers, wrap in
Number.ToText([Column1])
Thank you. Good advice with the ^