5 Replies Latest reply: Apr 22, 2015 3:38 AM by b p RSS

    Field Not Found Error and Failure to Load *

      Trying to load a small qvd containing conversions. Which I am able to load with other applications. However when I am using the current application I receive 'Field Not Found' If I load * then the load fails entirely.

       

      Any idea what the issue is?

       

      Happens in one other application for different source. Not sure if it is worth noting, but every time I save, it follows the 'save as' procedure rather than saving on top of the file.

       

      error.PNG

       

      let      FILEPATH_CONVERSIONS_CURRENCY = 'D:\ProgramData\QlikTech\SourceDocuments\SourceFiles\Master_Conversions\CurrencyExchangeRates.qvd';

      let      FILEPATH_CONVERSIONS_CURRENCY = 'D:\ProgramData\QlikTech\SourceDocuments\SourceFiles\Master_Conversions\CurrencyExchangeRates.qvd';

       

      CurrencyCode_Multiplier_Map:
      Mapping LOAD
      Currency_Code,
          USDPerUnit // Multiplier when loading currency
      FROM
      $(FILEPATH_CONVERSIONS_CURRENCY)(qvd);

       

       

       

       

      CurrencyConversion:
      LOAD *
      // Currency_Code,
      //     UnitsPerUSD, 
      //     Currency_Symbol,
      //     Currency_Name
      FROM
      $(FILEPATH_CONVERSIONS_CURRENCY)(qvd);