Table not found error

[#1]

Hi all,

I'm trying to load a table from a particular sheet, then concatenate a table from a different sheet.  this is the error message:

Table not found

Concatenate(qlikviewtest)

Load *

From

(ooxml, embedded labels, Table is Jan14)

this is the script i'm using:

['qlikviewtest']:

LOAD *

FROM

(ooxml, embedded labels, Table is Dec13);

Concatenate(qlikviewtest)

LOAD *   

From

(ooxml, embedded labels, Table is Jan14);

[#2 · Accepted solution]

Hi,

Just remove the brackets and quotes from the label:

qlikviewtest:

load *...

concatenate(qlikviewtest)

load *...

[aveeeeeee7en]

Try this:

qlikviewtest:

LOAD *

FROM

(ooxml, embedded labels, Table is Dec13);

Concatenate

LOAD *   

From

(ooxml, embedded labels, Table is Jan14);