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.

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago
= Table.AddColumn(#"prev step", "Concat", each [RECOMMENDED_BLK] & "/" & [RECOMMENDED_LOT])

 

Btw, why not concatenate columns in sql?

SELECT CONCAT(RECOMMENDED_BLK, '/', RECOMMENDED_LOT) AS RECOMMENDED_CONCAT

or

SELECT (RECOMMENDED_BLK + '/' + RECOMMENDED_LOT) AS RECOMMENDED_CONCAT

if "+" operator is supported by your db.

  • aishak12's avatar
    aishak12
    Helper IV
    5 years ago

    Hi, 

    I am receiving this error. I am trying to do this in PowerBI if possible. Thanks