topic Re: Field Not Found Error and Failure to Load * in QlikView

Field Not Found Error and Failure to Load *

Wed, 22 Apr 2015 07:02:56 GMT

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.

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

Re: Field Not Found Error and Failure to Load *

PrashantSangle — Wed, 22 Apr 2015 07:07:27 GMT

Hi,

Can you post your script and also provide screen shot error.

Regards

Re: Field Not Found Error and Failure to Load *

PrashantSangle — Wed, 22 Apr 2015 07:21:28 GMT

Hi,

When you do

Load *

from D:\ProgramData\QlikTech\SourceDocuments\SourceFiles\Master_Conversions\CurrencyExchangeRates.qvd

Did you get any error??

if no then let me know which field you got after completion of reload??

If yes, then what error you are getting??

Regards

Re: Field Not Found Error and Failure to Load *

Wed, 22 Apr 2015 07:24:05 GMT

Turns out the issue was caused by Section Access

Re: Field Not Found Error and Failure to Load *

PrashantSangle — Wed, 22 Apr 2015 07:27:27 GMT

Ok.

It means when you comment session access script then it is working fine

Re: Field Not Found Error and Failure to Load *

Wed, 22 Apr 2015 07:38:32 GMT

Hello, Please find the attached QVW. it is working properly