Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
NemoAndStitch22
Contributor III
Contributor III

Split string field into table rows

Hiya, 

 

I have a data set that has about 40 columns and one of those has 'Enquiry Numbers' which can hold 1-x amount of numbers, which I would like to split out, for example:   

ID | Enquiry Number

123 | 15, 25, 68, 52

124 | 2, 98, 34, 76

126 | 18, 24, 88, 92, 48

127 | 5

128 | 92, 16

 

and so on and so forth, what I would like to is split each Enquiry and have it pull in all the table data for that ID but only one of the Enquiry Numbers.

I've found this post with an answer: Suggested Solution 

However, the answer shows that you need to repeat the solution for each part of the field that needs splitting. 

I can have any number of Enquiry Numbers in this field, so don't want to have to repeat the process 50 times just to capture them all. 

Is there a better way?

Thanks in advance

Labels (1)
1 Solution

Accepted Solutions
Digvijay_Singh

I think the best way to create multiple rows out of one field is subfield function. In the script if we use something like subfield([Enquiry Number],','), It should create multiple row dynamically for each value separate by comma.

View solution in original post

2 Replies
Digvijay_Singh

I think the best way to create multiple rows out of one field is subfield function. In the script if we use something like subfield([Enquiry Number],','), It should create multiple row dynamically for each value separate by comma.

View solution in original post

NemoAndStitch22
Contributor III
Contributor III
Author

Omg, perfect! That has worked perfectly thank you so much!!!