13 Replies Latest reply: Feb 20, 2017 6:56 PM by Sunny Talwar RSS

    "Table not found" error in Qlik Sense

    Debashish Banerjee

      Hello all,

       

      I've started teaching myself Qlik Sense over the past two months and I've recently touched on advanced scripting techniques in order to get more comfortable with data manipulation. However, while I was doing one of the exercises in the manual, I was unable to load my data and got a "table not found error" even though my script looked exactly the same as was shown in the book. It's an error regarding the "Transactions" table while I tried to use a JOIN function. Any help will be a greatly appreciated and I thank you all in advance!

       

      Here's the script:

      Join(Transactions)

      LOAD

          "Transaction ID",

          "Salesman ID",

          Product,

          "Serial No",

          "ID Customer",

          "List Price",

          "Gross Margin"

      FROM [lib://Tutorial Files/Transactions.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

       

      Join(Transactions)

      LOAD

          "Salesman ID",

          Salesman,

          "Distributor ID"

      FROM [lib://Tutorial Files/Salesman.xlsx]

      (ooxml, embedded labels, table is Salesman);