topic Concatenate in load in QlikView

Concatenate in load

mwscott1 — Mon, 05 Jan 2015 22:02:03 GMT

I hope I am asking this correctly...

I have a SQL select statement and I have been able to use substr to narrow down my field to the 6 numbers I need AGT_6 (123456). now i need to add CL in front so AGT_6 (CL123456)

Hierarchy:

SQL SELECT substr(AGT_CD,3,6) as AGT_6

FROM ZDBA.ZAHRMAGC;

Re: Concatenate in load

Mon, 05 Jan 2015 22:05:20 GMT

(updated)

Try:

SQL SELECT 'CL' + substr(AGT_CD,3,6) as AGT_6

FROM ZDBA.ZAHRMAGC;

Re: Concatenate in load

Mon, 05 Jan 2015 22:14:36 GMT

I believe in SQL concatenate function is ||

So it would be like

SQL SELECT 'CL' || substr(AGT_CD,3,6) as AGT_6

FROM ZDBA.ZAHRMAGC;

you can do a preceding load

Load 'CL' & AGT_6 as AGT_6;

SQL SELECT substr(AGT_CD,3,6) as AGT_6

FROM ZDBA.ZAHRMAGC;