2 Replies Latest reply: Oct 11, 2013 5:22 AM by Miguel Domingos RSS

    Create intermediate tables not working

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