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.

flyingcheesehea
Contributor II

One field throwing error during reload

Hi folks,

Got one that's baffling me.

Here's the code:

AllOpenPoints:

SQL SELECT

    BatchId

    ,DivisionSKey

    ,ValidateEvent

FROM log.BusinessValidateEvents order by BatchID Desc;

Let vLatestBatch=FieldValue('BatchID',1);

CurrentOpenPoints:

NoConcatenate Load BatchId,

    DivisionSKey,

    ValidateEvent

Resident AllOpenPoints where BatchID='$(vLatestBatch)';

For some reason, I'm getting a "Field Not Found" error for BatchID every time I try to use it. However, it *is* pulling in data successfully! I've gotten nothing useful by running it in debug mode, I copied and pasted the code into a text editor to ensure there weren't any invisible characters around the field name... What could be causing this?

Thanks,

Kent

3 Replies
MVP & Luminary
MVP & Luminary

One field throwing error during reload

Hi,

Qlikview is case sensitive

Let vLatestBatch=FieldValue('BatchId',1);

Use BatchId instead BatchID .

Hope this helps you.

Regards,

Jagan.

One field throwing error during reload

Hi Kent,

Are you spelling the field right? Note that QlikView is case sensitive for field names as well, but the driver may allow you to send the SELECT statement in either upper or lowercase, but QlikView will take the original name in the source. In the variable you look for BatchID, but in the RESIDENT you load BatchId (the final "d" is lowercase).

Hope that helps.

Miguel

flyingcheesehea
Contributor II

One field throwing error during reload

Ugh... Thanks guys. It's amazing how our eyes can pass over such a tiny detail!

Community Browser