Outer Join Help

[johnso2080]

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

[nirav_bhimani]

Hi,

Try this,

Outer Join (VariantOrders)

LOAD VariantKey,
     Views

Resident VariantViews;

Regards,

Nirav Bhimani

[er_mohit · Accepted solution]

hiiii.

see the attached file

write outer join (variantOrder)

between two table..

[jagan]

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.

[johnso2080]

Great! Thanks very much!

[johnso2080]

Thank you

[johnso2080]

Thanks for your help