Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have varying levels and have to make concatenated key based on no of fields in it. How can I create a loop some thing like below?
let f=NoOfFields('LOCATIONLEVELS');
let f=($(f)-1)/4;
for i=1 to $(f)
Noconcatenate
Load *,
HIER_L0$(i)_NAME&' ('&HIER_L0$(i)_ID"&')' as LocationAtLevel#$(i)
Resident LocationLevels;
next i;