topic Concatenate Kilometer and meter in QlikView

Concatenate Kilometer and meter

Thu, 14 Apr 2016 20:34:01 GMT

Hi,

It's possible concatenating in script two columns and create a new one in this model?

Column KM: 357

Column M: 8

Result: 357008

sunny_talwar — Thu, 14 Apr 2016 20:36:08 GMT

May be like this:

LOAD [Column KM] & Num([Column M], '000') as Result

FROM Source;

LOAD Num(Num#([Column KM] & Num([Column M], '000'), '##')) as Result

FROM Source;

swuehl — Thu, 14 Apr 2016 21:42:58 GMT

You can also probably completely avoid the number formatting and (implicite) interpretation:

LOAD *,

KM*1000+M as Meter

INLINE [

KM, M

357, 8

];