topic Peek - Reading through table twice does not work in QlikView

Peek - Reading through table twice does not work

Wed, 05 Dec 2012 08:56:06 GMT

Hello, I have the issue, that reading through a table twice with "peek" doesn´t work with below code.

Mappings:

LOAD DestinationField,

[SourceFieldFileType_1],

[SourceFieldFileType_2]

FROM

[Data\Mapping.xlsx]

(ooxml, embedded labels, table is FieldMapping);

for y = 1 to 2

let vSourceColumnName = 'SourceFieldFileType_' & y

for x=0 to 73 // Set all "from-Fields" Typ y

let vmapfrom_$(x) = peek(vSourceColumnName,x,Mappings);

next x;

next y;

In first loop everthing is fine - contents of column1 of 74 records read.

In second loop - trying ti read contents of column2 of the same 74 records - I get NULL as result.

It is similar to (16.11.2011 jacq) (Peek funtion is not working...), but unfortunately that solution doesn´t help me.

Would be great, if someone has an idea.

Thanks, Klaus

Re: Peek - Reading through table twice does not work

jonathandienst — Wed, 05 Dec 2012 09:01:21 GMT

Klaus

Mappings should be in quotes in the peek statement

peek(vSourceColumnName, x, 'Mappings');

That might resolve the second pass through the table correctly.

Regards

Jonathan

Re: Peek - Reading through table twice does not work

Wed, 05 Dec 2012 09:31:28 GMT

Great - yes - thanks - it works -

Looks like QV´s support - letting it work in first time, although it´s a not set variable, while it just should be a fixed Value - confuses a QV beginner like me.

Re: Peek - Reading through table twice does not work

jonathandienst — Wed, 05 Dec 2012 09:34:03 GMT

I agree - things could be a little more consistent...