topic Re: merging multiple data source in to one in QlikView

merging multiple data source in to one

Fri, 19 Feb 2016 16:12:19 GMT

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

Re: merging multiple data source in to one

sunny_talwar — Fri, 19 Feb 2016 16:15:39 GMT

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);

Re: merging multiple data source in to one

Chanty4u — Fri, 19 Feb 2016 16:19:49 GMT

use left join for all tables

Re: merging multiple data source in to one

Chanty4u — Fri, 19 Feb 2016 16:20:16 GMT

andd store that into qvd.

hope this helps u

Re: merging multiple data source in to one

sunny_talwar — Fri, 19 Feb 2016 16:21:25 GMT

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

Re: merging multiple data source in to one

Chanty4u — Fri, 19 Feb 2016 16:24:38 GMT

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.

Re: merging multiple data source in to one

Fri, 19 Feb 2016 16:50:51 GMT

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

Re: merging multiple data source in to one

sunny_talwar — Fri, 19 Feb 2016 16:53:42 GMT

Not sure I understand your issue. Can you elaborate?

Re: merging multiple data source in to one

Fri, 19 Feb 2016 16:56:48 GMT

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

Re: merging multiple data source in to one

sunny_talwar — Fri, 19 Feb 2016 16:58:03 GMT

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

Re: merging multiple data source in to one

Fri, 19 Feb 2016 17:05:43 GMT

It didn't add new row that's the issue. because am adding data to already existing fields not new fields