Peek return Null Values

[heid_f]

Dear Community,

I try to iterate over an table MB_Ressource. This table is load from a qvd file:

// ********************************* MB_Ressource laden *********************************
MB_Ressource:
LOAD
	MB_Ressource.Firma & '-' & MB_Ressource.IdentAkt 								As %KEY_MB_Ressource_MB_Aktivitaet,
    MB_Ressource.Firma & '-' & MB_Ressource.IdentAkt & '-' & MB_Ressource.RessPos 	As %KEY_MB_Ressource_Schicht,
	*
From
	$(ImportPfad)MB_Ressource.qvd (qvd)
Where
	MB_Ressource.Firma = '$(Mandant)'
and MB_Ressource.StartTermin >= '$(AnaMinDatum)'
and MB_Ressource.IdentAkt = '417680'
;

Then I want to iterate over this table. Therefore I use a for loop and the Peek function, but Peek return Null Values (see Examples in attached screenshots).

The Peek returns null, but the MB_Ressource table have rows (see variable NumRows = 3).

Thanks for your Answers

[marcus_sommer]

The syntax isn't quite right - they must be:

let var = peek('Field', Index, 'Table');

and make sure that you address the right table.

Beside this such an outer loop over a table isn't really performant ... maybe there are better approaches.

- Marcus