Data model join

[nareshthavidishetty]

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

[Anil_Babu_Samineni]

May be Join(Location) ??

[sunny_talwar]

What is the main table here? Location or Status_Null_Min?

[aarkay29]

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;

[Anil_Babu_Samineni]

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

[nareshthavidishetty]

Hi ,

The main table is Status_Null_Min.

Thanks..

[nareshthavidishetty]

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

[sunny_talwar]

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