0 Replies Latest reply: Jul 19, 2017 8:58 AM by Kingsley Hoare RSS

    How to create custom field within 'Do while loop'?

    Kingsley Hoare

      let commaMax= substringcount(Input,',');

      Set comma=1;

       

       

      do while comma<=commaMax

      TEMP1:

      Load

      Name,

      SubField(Input,',',comma) as Input'$(comma)',

          SubField(Output,',',comma) as Output'$(comma)'

          Resident PROCESS_TABLE;

          comma=comma+1;

          crosstable(Name,Input'$(comma)');

          crosstable(Name, Output'$(comma)');

          loop;