topic Create intermediate tables not working in QlikView

Create intermediate tables not working

Fri, 11 Oct 2013 08:26:22 GMT

Here's my script that says

Field not found - <Full Text Reason Code>

Reasons:

Load [Full Text Reason Code] from Raw.qvd (qvd

Any Help?

qualify *;

Raw:

LOAD * FROM

[.\test.xlsx]

(ooxml, embedded labels, table is [table]);

STORE Raw into Raw.qvd;

Reasons:

Load [Full Text Reason Code] from Raw.qvd (qvd);

STORE Reasons into Reasons.qvd;

Pivot:

Load *

FROM Raw.qvd (qvd);

bbi_mba_76 — Fri, 11 Oct 2013 08:31:06 GMT

Hi,

maybe it is because you use the qualify *, so the fieldname is Raw.[Full Text Reason Code]

Fri, 11 Oct 2013 09:22:31 GMT

because you use the qualify *, so the fieldname is [Raw.Full Text Reason Code]