7 Replies Latest reply: Jun 16, 2015 9:54 PM by Derek Kibble RSS

    Seemingly simple left join returns general script error

    Derek Kibble

      I am loading data from 2 tabs of a spreadsheet, and then joining them in Qlikview. It seems like a reasonably simple task, but I just keep getting a General Script Error on reload. I tried doing the same with a basic inline load and had the same issue. What am I missing??

       

      If I Exit Script just before the left join, it runs OK, and creates the 2 tables as expected.

       

      COGS_Split_Temp:

      CrossTable(Month, Data, 2)

      LOAD [Line Type],

           ItemType,

           [1],

           [2],

           [3],

           [4],

           [5],

           [6],

           [7],

           [8],

           [9],

           [10],

           [11],

           [12]

      FROM

      [C:\Users\dkib\Desktop\QlikViewDataUpdate2\COGS Split.xlsx]

      (ooxml, embedded labels, table is UnitSplit)

      WHERE([Line Type] = 'Detail');

       

       

      COGS_Split:

      LOAD

        num#(Month)&ItemType as Key,

        Data as UnitSplit,

        num#(Month) as Month,

        ItemType

      resident COGS_Split_Temp;

       

       

      drop table COGS_Split_Temp;

       

       

      /////////////////////////////

      COGS_Split_Temp1:

      CrossTable(Month1, Data, 2)

      LOAD [Line Type],

           ItemType,

           [1],

           [2],

           [3],

           [4],

           [5],

           [6],

           [7],

           [8],

           [9],

           [10],

           [11],

           [12]

      FROM

      [C:\Users\dkib\Desktop\QlikViewDataUpdate2\COGS Split.xlsx]

      (ooxml, embedded labels, table is UnitCost)

      WHERE([Line Type] = 'Detail');

       

       

      COGS_Cost:

      LOAD

        num#(Month1)&ItemType as Key,

        Data as UnitCost

      resident COGS_Split_Temp1;

       

       

      drop table COGS_Split_Temp1;

       

       

      left join (COGS_Split)

      LOAD

        Key,

        UnitCost

      resident COGS_Cost;

       

       

       

      17/06/2015 9:37:38 AM: 0230  COGS_Cost:

      17/06/2015 9:37:38 AM: 0231  LOAD

      17/06/2015 9:37:38 AM: 0232   num#(Month1)&ItemType as Key,

      17/06/2015 9:37:38 AM: 0233   Data as UnitCost

      17/06/2015 9:37:38 AM: 0234  resident COGS_Split_Temp1

      17/06/2015 9:37:38 AM:       2 fields found: Key, UnitCost, 24 lines fetched

      17/06/2015 9:37:38 AM: 0236  drop table COGS_Split_Temp1

      17/06/2015 9:37:38 AM: 0238  left join (COGS_Split)

      17/06/2015 9:37:38 AM: 0239  LOAD

      17/06/2015 9:37:38 AM: 0240   Key,

      17/06/2015 9:37:38 AM: 0241   UnitCost

      17/06/2015 9:37:38 AM: 0242  resident COGS_Cost

      17/06/2015 9:37:38 AM:       2 fields found: Key, UnitCost, 24 lines fetched

      17/06/2015 9:37:38 AM:       Joining/Keeping

      17/06/2015 9:37:38 AM:       General Script Error

      17/06/2015 9:37:38 AM:       Execution Failed

      17/06/2015 9:37:38 AM:      Execution finished.