Qlikview

[Sonalbjr]

I have 2 columns and I have to combine the strings of both the columns via writing a script in the script editor.

For eg. Column 1 = 45

Column 2 = 67

How to combine them to form 4567 in Qlikview?

[JuanGerardo]

Hi @Sonalbjr, why don't you concatenate them as strings?

[Column 1] & [Column 2] AS MyNewColumn

You can also use Num() function if you need any format for the numbers when converting to text, for example:

Num([Column 1], '000') & Num([Column 2], '000')

JG