Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kingsleyh
New Contributor II

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

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;

Community Browser