Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
nareshthavidishetty
Contributor III

Data model join

Hi,

How to join the bold to the main table

Location:

left Join(Status_Null_Min)

LOAD Distinct BBITNB as Application_Number,

    BBAACD as Location;

SQL SELECT BBITNB,

    BBAACD

FROM ...00D60.PDBF.CAPP;

Load

LocationNbr as Location,

District_RetailScorecard

FROM

[.xlsx]

(ooxml, embedded labels, table is [Store Locations]) where District_recard <> 'Clece' ;

Thanks..

Tags (1)
7 Replies
Highlighted

Re: Data model join

May be Join(Location) ??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Re: Data model join

What is the main table here? Location or Status_Null_Min?

Highlighted
aarkay29
Valued Contributor

Re: Data model join

left Join(Status_Null_Min) or just Join(Status_Null_Min) .


It would join the main table on the key location which was joined from 00D60.PDBF.CAPP;

Highlighted

Re: Data model join

Load

LocationNbr as Location,

District_RetailScorecard

FROM

[.xlsx]

(ooxml, embedded labels, table is [Store Locations]) where District_recard <> 'Clece' ;

Thanks..

You don't have field called District_recard then how you calling the where condition with in the memory??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
nareshthavidishetty
Contributor III

Re: Data model join

Hi ,

The main table is Status_Null_Min.

Thanks..

Highlighted
nareshthavidishetty
Contributor III

Re: Data model join

Hi,

It is modified while posting.

Here it is..

Load

LocationNbr as Location,

District_RetailScorecard

FROM

[.xlsx]

(ooxml, embedded labels, table is [Store Locations]) where District_RetailScorecard<> 'Clece' ;


Thanks..

Highlighted

Re: Data model join

May be this:

Left Join(Status_Null_Min)

Load LocationNbr as Location,

     District_RetailScorecard

FROM

[.xlsx]

(ooxml, embedded labels, table is [Store Locations]) where District_recard <> 'Clece' ;