topic Re: Outer Join Help in QlikView

Outer Join Help

johnso2080 — Fri, 11 Jan 2013 12:27:27 GMT

Hello,

I have two tables as below...

VariantOrders:

Date	Item	Variant_Key	Orders
1 Jan	1	1	123
1 Jan	1	2	324
1 Jan	1	3	354
2 Jan	1	4	634
2 Jan	1	5	344

VariantViews:

Date	Item	Variant_Key	Views
1 Jan	1	1	332
1 Jan	1	2	112
1 Jan	1	6	467
2 Jan	1	7	578
3 Jan	1	7	654

I want to end up with a link table like:

Date	Item	Variant_Key	Orders	Views
1 Jan	1	1	123	332
1 Jan	1	2	324	112
1 Jan	1	3	354	-
1 Jan	1	6	-	467
2 Jan	1	4	634	-
2 Jan	1	5	344	-
2 Jan	1	7	-	578
3 Jan	1	7	-	654

The 'Variant_Key' is basically a concatination of 'Item' and 'Date' and is unique.

I need to do an 'outer' join, but need to keep the 'Date' and 'Item' fields in the link table as they are used to link other tables.

Can anyone advise?

Many Thanks

Darren

Re: Outer Join Help

nirav_bhimani — Fri, 11 Jan 2013 12:38:11 GMT

Hi,

Try this,

Outer Join (VariantOrders)

LOAD VariantKey,
Views

Resident VariantViews;

Regards,

Nirav Bhimani

Re: Outer Join Help

er_mohit — Fri, 11 Jan 2013 12:59:52 GMT

hiiii.

see the attached file

write outer join (variantOrder)

between two table..

Re: Outer Join Help

jagan — Fri, 11 Jan 2013 13:33:10 GMT

HI,

Try this

Data:

LOAD

Date,

Item,

Variant_Key,

Orders

FROM Source1;

Outer join (Data)

LOAD

Date,

Item,

Variant_Key,

Views

FROM Source1;

Hope this helps you.

Regards,

Jagan.

Re: Outer Join Help

johnso2080 — Fri, 11 Jan 2013 15:14:07 GMT

Great! Thanks very much!

Re: Outer Join Help

johnso2080 — Fri, 11 Jan 2013 15:14:21 GMT

Thank you

Re: Outer Join Help

johnso2080 — Fri, 11 Jan 2013 15:14:37 GMT

Thanks for your help