loop to get conactenated field

Anonymous — Thu, 23 Feb 2017 17:13:54 GMT

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;

topic loop to get conactenated field in QlikView