topic Re: Table not found error in QlikView

Table not found error

Sat, 12 Jul 2014 19:23:18 GMT

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

Sat, 12 Jul 2014 19:45:57 GMT

Hi,

Just remove the brackets and quotes from the label:

qlikviewtest:

load *...

concatenate(qlikviewtest)

load *...

aveeeeeee7en — Sat, 12 Jul 2014 19:59:19 GMT

Try this:

qlikviewtest:

LOAD *

FROM

(ooxml, embedded labels, Table is Dec13);

Concatenate

LOAD *

From

(ooxml, embedded labels, Table is Jan14);