Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
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
Master II
Master II

hiiii.

see the attached file

write outer join (variantOrder)

between two table..

View solution in original post

6 Replies
Partner
Partner

Hi,

Try this,

Outer Join (VariantOrders)

LOAD VariantKey,
     Views

Resident VariantViews;


Regards,

Nirav Bhimani

Master II
Master II

hiiii.

see the attached file

write outer join (variantOrder)

between two table..

View solution in original post

MVP & Luminary
MVP & Luminary

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.

Contributor
Contributor

Great! Thanks very much!

Contributor
Contributor

Thank you

Contributor
Contributor

Thanks for your help