topic cocnatenate fields? in QlikView

cocnatenate fields?

Mon, 08 Dec 2014 10:58:54 GMT

i want concatenate fields using chr(39)

how like

field1 &chr(39) &filed2 like this how ?

its_anandrjs — Mon, 08 Dec 2014 11:04:22 GMT

Hi,

Expression is correct try this in any list box expression or in load script

Ex:-

=Year &chr(39)&Month

Load

Year &chr(39)&Month as New

From Source;

chr(39) returns ( ' ) symbol

Regards

Anand

Anonymous — Mon, 08 Dec 2014 11:04:44 GMT

Yup, that is the way to do it.

Is there any specific problem you are facing ?

its_anandrjs — Mon, 08 Dec 2014 11:10:33 GMT

For better you can use chr(45) this returns ( - )

Load

field1 &chr(45)& field2 as New

From Source;

Regards

Anand

Mon, 08 Dec 2014 11:14:45 GMT

I prefer pipe (chr124) myself , dash I find in data to often