merging multiple data source in to one

[#1]

Find attached I want to store data source I left load into one qvd what do I do?

[sunny_talwar]

May be this:

Class:

LOAD [S/N],

     CLASS,

     Descrition,

     GROSS,

     NET

FROM

[\Book2.xlsx]

(ooxml, embedded labels, table is Classes);

Left Join (Class)

LOAD [DT number],

Descrition

FROM

[\Book2.xlsx]

(ooxml, embedded labels, table is Link);

Left Join (Class)

LOAD

     HOSTEL,

     Name,

     [DT number],

     Cost

FROM

[\Book2.xlsx]

(ooxml, embedded labels, table is [Hostel info]);

STORE Class into Class.qvd(qvd);

[Chanty4u]

use left join for all tables

[Chanty4u]

andd store that into qvd.

hope this helps u

[sunny_talwar]

You have gone from being Sureshqv -> Chanty 4u -> suri qv in a matter of a day . Whom are you trying to hide from

[Chanty4u]

hey sunny....i dnt knw now am chkng wen its chnged to suri again?

my nik name is chanty .so i chnged.            while creating Qlik community login  I hve givn name as suri qv.

so i changed.

[#7]

I did left Join but the data  in the table B are not showing after joining but if I do no concatenate it shows but I suspect its not correct.. because if it actually join it will show in the field

[sunny_talwar]

Not sure I understand your issue. Can you elaborate?

[#9]

If I left join the data in both fields are merged right? But in this case the I cant find the data of table B in table A I join it with

[sunny_talwar]

It should add new columns and not rows, I hope you know that right?