Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
May be Join(Location) ??
What is the main table here? Location or Status_Null_Min?
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;
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??
Hi ,
The main table is Status_Null_Min.
Thanks..
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..
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' ;