0 Replies Latest reply: Feb 23, 2017 12:13 PM by Praveena Velagapudi RSS

    loop to get conactenated field

    Praveena Velagapudi

      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;