PEEK not working on inline loaded table

[#1]

Hi,

In the example below, the variable vSPOTReloadDate remains empty after the PEEK statement. When I try the PEEK function with a 'normally' loaded table, it works just fine. The SPOTProperties table get loaded fine.

I can't find this limitation in the docs. Is this by design or am I missing something here ?

Any help would be greatly appreciated.

Jan

SPOTProperties:

LOAD * INLINE
[PropertyID, PropertyName, PropertyValue
0, SPOTProp1, 23
1, SPOTProp2, 67];

LET vSPOTReloadDate = Peek('PropertyValue', 0, 'SPOTProperties');

[vupen]

Small correction is needed in the Peek syntax. The table name should not be in quotes. Correct code in your example will be:

Let VSPOTReloadDate = Peek('PropertyValue',0,SPOTProperties);