Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Champion III
Champion III

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
Champion III
Champion III

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
Champion III
Champion III

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