Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikconsultant
Creator II
Creator II

Searching for a function?

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

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

You could use:

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

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

- Marcus

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

You could use:

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

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

- Marcus

View solution in original post