Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Helper IV
4 years ago

Changing data type

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.

 

Need Help
Show and Tell

3 Replies

    • nataliesmiy1357's avatar
      nataliesmiy1357
      Helper IV
      4 years ago

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

       

      How do I fix this?

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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