Peek not working

Tue, 22 Oct 2013 12:24:41 GMT

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

Re: Peek not working

MayilVahanan — Tue, 22 Oct 2013 12:33:35 GMT

Try like this

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

Tue, 22 Oct 2013 12:39:51 GMT

Hi,

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

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