Forum Discussion
Solved
Power query - concatenate text columns
Hi, I need to combine two text columns. I've tried it in the custom column with the & Formuala, but I get an error. = Table.AddColumn(#"Geänderter Typ", "Text.Combine", each [FCURR]&[Period]) ...
is [FCURR] and [Period] of type Text? What is the error you get?
Also, where is your function Text.Combine( )? It looks like you've just joined with '&' which should give you something like:
[Column1]&[Column2] outputs 'helloworld'
Text.Combine({[Column1],[Column2]}," " ) outputs 'hello world'
is [FCURR] and [Period] of type Text? What is the error you get?
Also, where is your function Text.Combine( )? It looks like you've just joined with '&' which should give you something like:
[Column1]&[Column2] outputs 'helloworld'
Text.Combine({[Column1],[Column2]}," " )
outputs 'hello world'
thanks for your fast reply....with two text columns it worked now :-)
=Text.Combine({[FCURR],[TCURR]}," " )
