Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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