topic Data model join in QlikView

Data model join

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: Data model join

Anil_Babu_Samineni — Fri, 03 Mar 2017 16:12:17 GMT

May be Join(Location) ??

Re: Data model join

sunny_talwar — Fri, 03 Mar 2017 16:12:52 GMT

What is the main table here? Location or Status_Null_Min?

Re: Data model join

aarkay29 — Fri, 03 Mar 2017 16:14:14 GMT

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;

Re: Data model join

Anil_Babu_Samineni — Fri, 03 Mar 2017 16:16:51 GMT

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??

Re: Data model join

nareshthavidishetty — Fri, 03 Mar 2017 16:31:44 GMT

Hi ,

The main table is Status_Null_Min.

Thanks..

Re: Data model join

nareshthavidishetty — Fri, 03 Mar 2017 16:33:20 GMT

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..

Re: Data model join

sunny_talwar — Fri, 03 Mar 2017 16:33:55 GMT

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' ;