Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
It works !!
Many thanks and Ciao