How to joind two fields into one

[#1]

Dear all,

I'm new on QlikView and I don't know how to join to varchar fields. I would like to join into my script, the Company code field with the customer code field.

Does anybody know how to do it ?

thanks in advance for your replies

[its_anandrjs · Accepted solution]

Hi,

You can make a single field with two fields or from two different tables you need to write

Load

Field1,

Field2,

Field1&Field2 as NewField

From Table...

By this you can make a sigle field.

Regards,

Anand

[its_anandrjs]

Hi,

See the attached sample file where you see this code by this i concat

ComanyCode & CustomerCode as NewField

See the sample file.

Regards

Anand

[#4]

It works !!

Many thanks and Ciao