Need to break down a column into rows with iterative script

yashcena — Thu, 07 Apr 2022 09:54:36 GMT

Hi,

I have the following data in my data model:

I need to break up the ORDERED_PRODUCTS column into rows like this:

I can use subfield function to extract each of "RecurringDue", "ProdQuantity", "ProdName", "ProdDesc" etc.

But the problem is 1st ID has 3 products, 2nd ID has 2 products and 3rd ID has 4 products. I'm not able to figure out how to write the script so that it first checks how many {.....}, {......}, {.....} are there in each row and then use "subfield" that many times.

So for 1st row, we have three {....} - need to use subfield 3 times
2nd row, we have two {...} - need to use subfield 2 times....so on and so forth.

Any help would be greatly appreciated.

@sunny_talwar

Re: Need to break down a column into rows with iterative script

marcus_sommer — Thu, 07 Apr 2022 12:47:40 GMT

You don't need to know how many parts are there. You could use subfield() just with two parameters and it will creates all appropriate records.

- Marcus

topic Need to break down a column into rows with iterative script in QlikView

Need to break down a column into rows with iterative script

Re: Need to break down a column into rows with iterative script