Concatente

[#1]

Tab1:

LOAD * INLINE [

    ID, First Name

    1, ABC

    2, DEF

    3, GHI

    4, kiy

];

     Tab2:

LOAD * INLINE [

    ID, Last Name

    1, ttt

    2, YYY

    3, UUU

    4, RRR

];

I need to make changes in script to get the Full name (First Name & Last name)

[#2]

Tab1:

LOAD * INLINE [

    ID, First Name

    1, ABC

    2, DEF

    3, GHI

    4, kiy

];

left join(Tab1)

LOAD * INLINE [

    ID, Last Name

    1, ttt

    2, YYY

    3, UUU

    4, RRR

];

tab3:

Load *, [First Name] &' '&[LastName] as Name

resident Tab1;

drop table Tab1;

[#3]

not working

[#4 · Accepted solution]

just a space in Last Name:

Tab1:

LOAD * INLINE [

    ID, First Name

    1, ABC

    2, DEF

    3, GHI

    4, kiy

];

left join(Tab1)

LOAD * INLINE [

    ID, Last Name

    1, ttt

    2, YYY

    3, UUU

    4, RRR

];

tab3:

Load *, [First Name] &' '&[Last Name] as Name

resident Tab1;

drop table Tab1;

[#5]

did u get the answer ?

[shree909]

Try  this

LOAD * INLINE [

    ID, First Name

    1, ABC

    2, DEF

    3, GHI

    4, kiy

];

     Tab2:

join(Tab1)

LOAD * INLINE [

    ID, Last Name

    1, ttt

    2, YYY

    3, UUU

    4, RRR

];

table c:

load

id,

//Firstname,

//Lastname

firstname &'-'& Lastname as Fullname,

resident Tab1

store tablec  into  location.qvd(qvd)

drop table Table c;