Concatenate Values From Two Columns for Unique ID

Power Query
1

Hi, I have two columns, one numbers (Material ID), and one text (Shop Number). I wish to concatenate them into a Unique ID column to link to another table of the same ID. What might be the best approach for this in the Query Editor?

Thanks.

2

Hi @Dplex,

Try this in a custom column:

Number.ToText( [Material ID] ) & [Shop Number]

image
image713×449 11.1 KB

Dplex IDs.pbix (16.6 KB)

2 Likes
3

Hey Dplex,

Alternatively, you can merge columns via the Transform or Add Column menu.
It depends if you want to keep the original columns or not from which tab you do the merge.
This option allows you to easily insert a delimiter in case you’d like to split the Unique ID column in a later stage.

image
image1103×631 30.8 KB

2 Likes
4

Hi Maikelshuvit, thx for that but yes, I’ll still require the the original columns. Cheers for that anyway.

5

Thanks Jamie, that’s excellent.