Peek not working

[#1]

The following peek call return NULL. Why?

qualify *;

Raw:

LOAD RUN_ID,

     EXECUTION_DATE

FROM

[..\Data\Raw.tabdel]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Aggregates:

LOAD RUN_ID,

     EXECUTION_DATE

FROM

[..\Data\foo.tabdel]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

MaxRunId:

inner keep (Aggregates)

load max([Aggregates.RUN_ID]) as MAX_RUN_ID

resident Aggregates

group by [Aggregates.RUN_ID];

let mypeek = peek('[MaxRunId.MAX_RUN_ID]',0,'MaxRunId');

MaxAggregates:

LOAD RUN_ID,

     EXECUTION_DATE

FROM

[..\Data\MIB1-FOO-aggregates.tabdel]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

where RUN_ID = $(mypeek);

unqualify *;

Thanks,

Miguel

[MayilVahanan]

HI

Try like this

Let mypeek = peek('[MAX_RUN_ID]',0,'MaxRunId');

[#3 · Accepted solution]

Hi,

Try the same peek but without [ ] over qualified field name

let mypeek = peek('MaxRunId.MAX_RUN_ID',0,'MaxRunId');