Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

thnkgreen
Contributor

Proper Inner Join syntax not working

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;










1 Reply
shree909
Valued Contributor II

Re: Proper Inner Join syntax not working

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

Community Browser