join two fields

[#1]

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;

[#2]

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]

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;