topic Re: Left join(Small Help) in QlikView

Left join(Small Help)

ajaykumar1 — Thu, 18 Sep 2014 10:33:33 GMT

Hi All,,

How to reduce the size of the application.

I have two data sources.Before left join source1 have 9 lacks records and 27MB size.After left join total records(settings-documentsProperties--tables) is around 47 Lacks and size is 135 MB.

Note : one ID have multiple DM,PM,PG

Data linkage as below.

Table:

Load ID,

etc..

from source1; //Total records 9Lacks

left join

Load ID,

DM,

PM,

from source2; //540 from excel

Desired o/p : List of ID's from source1 and their respective DM,PM,PG from source2.

Thanks,

Ajay

Re: Left join(Small Help)

ashfaq_haseeb — Thu, 18 Sep 2014 10:55:47 GMT

Hi,

Make sure you have same field name in both table for the one you are joining.

Can you post your script here.

Regards

ASHFAQ

Re: Left join(Small Help)

ajaykumar1 — Thu, 18 Sep 2014 10:56:06 GMT

Any hint from anyone?

Thanks,

Ajay

Re: Left join(Small Help)

ajaykumar1 — Thu, 18 Sep 2014 10:58:29 GMT

Thanks Ashfaq.The joining name is same.What am expecting is one ID with multiple PM,DM,PG so it may considering the record count based on multiple Pm,dm,pg values.

Correct me if am wrong.

Ajay

Re: Left join(Small Help)

ashfaq_haseeb — Thu, 18 Sep 2014 11:01:17 GMT

Ok.

This is known thing, this is how it works.

What is your desired o/p.

Can you attach few lines of sample data.

Regards

ASHFAQ

Re: Left join(Small Help)

ajaykumar1 — Thu, 18 Sep 2014 11:14:26 GMT

Based on the data and desired o/p we can't change the size of the application ..correct?

The output also coming properly when am doing some random validation.My intension is to reduce the size of the application as because of currently am working in personal with some lease license.

Its creating problems to open in local computer.

Thanks,

Ajay

Re: Left join(Small Help)

ashfaq_haseeb — Thu, 18 Sep 2014 11:18:23 GMT

With this model you can't.

You have to look at business requirement first.

If that's the only solution consider increasing ram on your machine.

Regards

ASHFAQ