Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to joind two fields into one

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

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

3 Replies
its_anandrjs

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

Not applicable
Author

It works !!

Many thanks and Ciao