Searching for a function?

[qlikconsultant]

I have a table with a field which includes number separated with comma. I need a function which generates line for each number. Is there a function for that?

Example:

Colum 1   Colum 2

A                             2, 5 ,3

B                             8

Goal:

Colum 1   Colum 2

A                            2

A                            5

A                            3

B                             8

[marcus_sommer · Accepted solution]

You could use:

subfield([Column 2], ',') as [Column 2]

within the load to create for each item an extra record.

- Marcus