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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
kingsleyh
Partner - Contributor II
Partner - 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;

0 Replies