Proper Inner Join syntax not working - Qlik Community

Anonymous · ‎2013-07-01

Hello all. I am trying to perform a simple inner join between two tables. I am not sure if this syntax is right but cannot figure out why it would not be. I truly appreciate any help on this issue. Thanks.

       tblCore_A:
       LOAD '1' AS RowMaster, PSPLN As Task_Number, RESERVELOCATION, PSCASN, PSSYR + PSSTYL + PSSSFX AS SKU, PSSZDS,
       PSSQTY, PSQPUL, PSRLOC AS ActiveLocation
       RESIDENT tblPull;

       INNER JOIN(tblCore_A)

       Load Task_Number
       RESIDENT tblTasks
       WHERE available = FALSE;

shree909 · ‎2013-07-01

Hi

To work inner join u need to have same column or filednames same

but in tblCore_A i dont fine the field name Task_Number,

thats the reason its throwing an error.......