Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

loop to get conactenated field

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;

0 Replies