Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
johnso2080
New Contributor

Outer Join Help

Hello,
I have two tables as below...
VariantOrders:
DateItemVariant_KeyOrders
1 Jan11123
1 Jan12324
1 Jan13354
2 Jan14634
2 Jan15344
VariantViews:
DateItemVariant_KeyViews
1 Jan11332
1 Jan12112
1 Jan16467
2 Jan17578
3 Jan17654
I want to end up with a link table like:
DateItem Variant_KeyOrdersViews
1 Jan11123332
1 Jan12324112
1 Jan13354-
1 Jan16-467
2 Jan14634-
2 Jan15344-
2 Jan17-578
3 Jan17-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
1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: Outer Join Help

hiiii.

see the attached file

write outer join (variantOrder)

between two table..

6 Replies
nirav_bhimani
Contributor III

Re: Outer Join Help

Hi,

Try this,

Outer Join (VariantOrders)

LOAD VariantKey,
     Views

Resident VariantViews;


Regards,

Nirav Bhimani

er_mohit
Honored Contributor II

Re: Outer Join Help

hiiii.

see the attached file

write outer join (variantOrder)

between two table..

MVP
MVP

Re: Outer Join Help

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
New Contributor

Re: Outer Join Help

Great! Thanks very much!

johnso2080
New Contributor

Re: Outer Join Help

Thank you

johnso2080
New Contributor

Re: Outer Join Help

Thanks for your help

Community Browser