Unnest dynamic amount of data stored in field value using LOAD While:

QlikView_Unnest_Field_Data_While.qvs

// unnest data of field value:
Input:
LOAD * INLINE [
    ACCOUNT, SUPPLIES
    001, "Apples,Bananas,Tomatos"
    002, "Bread,Butter,Cheese"
    003, "Pretzel,Wuerstl"
];

Result:
LOAD ACCOUNT, subfield(SUPPLIES, ',', IterNo()) as SUPPLY  
Resident Input
While IterNo()<=SubStringCount(SUPPLIES, ',')+1;

Hi Ralph,

First of all thanks for sharing all your code snippets. Regarding this one, wouldn't it be easier to do this for the Result table? Am I missing something?

Result:
LOAD ACCOUNT,
SUPPLIES,
subfield(SUPPLIES, ',') as SUPPLY
Resident Input;

Thanks,
Regards,
Ignacio

Yes, you're right. This was oversimplified. Actually, cannot remember why I needed a While loop, probably to calculate something else in combination with SubField, e.g having a counter or else..