Forum Discussion

aishak12's avatar
aishak12
Helper IV
5 years ago
Solved

Joining two columns into one

Hi All,    I am importing my data with SQL and have two columns (RECOMMENDED_BLK & RECOMMENDED_LOT). I would like to comine these values into a new column while having a slash between them.    Fo...
Need Help
  • Portrek's avatar
    Portrek
    5 years ago

    Hi aishak.

    You can inside power query add a custon column with the code below

    Text.Combine({Text.From([RECOMMMENDED_BLK], "pt-BR"), "/", [RECOMMENDED_LOT]})

     

    best regards.

Portrek's avatar
Portrek
Resolver III
5 years ago

Hi aishak.

You can inside power query add a custon column with the code below

Text.Combine({Text.From([RECOMMMENDED_BLK], "pt-BR"), "/", [RECOMMENDED_LOT]})

 

best regards.

aishak12's avatar
aishak12
Helper IV
5 years ago

This worked thank you. Recommended_BLK had three M's in your response.