Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

5 Replies
PrashantSangle
Not applicable

Re: Field Not Found Error and Failure to Load *

Hi,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
PrashantSangle
Not applicable

Re: Field Not Found Error and Failure to Load *

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

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Field Not Found Error and Failure to Load *

Turns out the issue was caused by Section Access

PrashantSangle
Not applicable

Re: Field Not Found Error and Failure to Load *

Ok.

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

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Field Not Found Error and Failure to Load *

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