Hi, how can I merge variables/colums?

[mlarruda]

Hi, I have one table with three columns/variables: FIRST_NAME, MIDDLE_NAME and LAST_NAME. How can I merge (with spaces between) to get a FULL NAME table?

[qlikwiz123 · Accepted solution]

Maybe something like this?

FIRST_NAME & ' ' & MIDDLE_NAME & ' ' & LAST_NAME as FULL_NAME

[mlarruda]

Thanks but where I type it? In the dimensions formula window?

[mlarruda]

Worked! Thanks!

[qlikwiz123]

You can do it in the Script if you want to reuse this new Field in the model.

Or else, FIRST_NAME & ' ' & MIDDLE_NAME & ' ' & LAST_NAME in Dim or Exp should do the trick.