Changing data type

[nataliesmiy1357]

I am tryin to create a new column in my tables in power query, and I keep getting this error.  I'm not sure how to change the datatype or make it so that this works.  I am trying to create a new custom column with the employee id and moduleid. Attached are the two screenshots that I get when I try to create this.  Thanks in advance.

[Anonymous]

Hi @nataliesmiy1357,
AFAIK, the current power query not support do concatenate operations with different data types.

In my opinion, I'd like to suggest you use the 'Text.From' function to transform these values to text before concatenating operations:

Text.From([Emploee Id]) & "|" & Text.From([ModuleID])

Regards,
Xiaoxin Sheng

[amitchandak]

@nataliesmiy1357 , I think employee Id is number , convert to text using

Number.ToText([Emploee Id])

[nataliesmiy1357]

I tried that.... and now I'm getting this error:

How do I fix this?