Create intermediate tables not working

[#1]

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]

Hi,

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

[#3 · Accepted solution]

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