topic Re: join two fields in QlikView

join two fields

Thu, 24 Oct 2013 09:29:43 GMT

hi i have two fields in my data model that i wish to merge together.

i have derived the logic into these two fields that connect to the order field.

how is this done in QV?

Endcustomer:

load *,

EC2013 as EC,

EC2012 as EC

Resident

EC_temp;

drop table EC_temp;

Thu, 24 Oct 2013 09:40:09 GMT

You can do it in two times, with Concatenate.

Maybe this would work :

Endcustomer:

LOAD EC2013 as EC

Resident

EC_temp;

CONCATENATE(Endcustomer)

LOAD EC2012 as EC

Resident

EC_temp;

drop table EC_temp;

er_mohit — Thu, 24 Oct 2013 09:41:26 GMT

try to use concatenate function to merge it like this way

Endcustomer:

load *,

EC2013 as EC,

EC2012

Resident

EC_temp;

concatenate

Load Primary key_Field //from above table the primary key which merge the EC2012 to EC

EC2012 as EC

resident Endcustomer;

drop table EC_temp;