Concatenate Kilometer and meter

[#1]

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 · Accepted solution]

May be like this:

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

FROM Source;

or

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

FROM Source;

[swuehl]

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

LOAD *,

      KM*1000+M as Meter

INLINE [

KM, M

357, 8

];