topic Re: Concatente in QlikView

Concatente

Wed, 09 Jan 2013 13:24:43 GMT

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)

Re: Concatente

Wed, 09 Jan 2013 13:31:19 GMT

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;

Re: Concatente

Wed, 09 Jan 2013 13:40:00 GMT

not working

Re: Concatente

Wed, 09 Jan 2013 13:43:01 GMT

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;

Re: Concatente

Wed, 09 Jan 2013 14:11:29 GMT

did u get the answer ?

Re: Concatente

shree909 — Wed, 09 Jan 2013 14:31:36 GMT

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;