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

kingsleyh — Wed, 19 Jul 2017 12:58:22 GMT

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;

topic How to create custom field within 'Do while loop'? in App Development