"Table not found" error in Qlik Sense

[Anonymous]

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);

[sunny_talwar]

Can you share the script before this?

[Anonymous]

That is the entire script in that section of the data load editor. I'm attaching all sections of script if it is of any help as well as the error message I receive when I try and load the data. I can send screenshots of the instructions or files if they may be helpful. Thank you once again.

[sunny_talwar]

Is this your transaction table?

If it is, then specify the name

Transactions:

CrossTable(Month, Sales)

LOAD Product,

          ....

FROM .....;

Qlik Sense doesn't know (until you tell it), that this is transactions table.

[Anonymous]

That is the product table. I'm attaching the transaction table, it is within the script and I selected the data prior to writing the code.

[sunny_talwar]

Oh so you need to do this:

Product:

CrossTable(Month, Sales)

LOAD Product,

          ....

FROM .....;

Join (Product)

LOAD ....

FROM ...;

You need to specify the name of the table you are joining into. Not the one you are joining from.

[Anonymous]

Is that within the same section with the CrossTable ... what do I write underneath the Join(Product) section? (that LOAD .... FROM ...; part)? Thanks again, much appreciated.

[sunny_talwar]

Join (Product)

[Anonymous]

It is still giving me an error despite doing that, I'm not sure. I added the JOIN(Product) at the beginning of the script and it doesn't work.

[sunny_talwar]

Change this also

Join(Product)