Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vimalthehero
Contributor III
Contributor III

data transformation : Split column and duplicate rows

im looking for a Qliksense data transformation solution where we split comma separated column data and make it duplicated as shown below.

can someone please suggest some break through on it. waiting for the ideas.

Data load script ideas for below transformation

Input data

INPUT
TYPE CARNAME NUMBERLIST
JEEP MAHINDRA 01,03,33,44
TRUCK SCANIA 66,04,55,33,55
BIKE YAMAHA 54,76,43,67

 

Expected output

OUTPUT
TYPE CARNAME NUMBERLST
JEEP MAHINDRA 01
JEEP MAHINDRA 03
JEEP MAHINDRA 33
JEEP MAHINDRA 44
TRUCK SCANIA 66
TRUCK SCANIA 04
TRUCK SCANIA 55
TRUCK SCANIA 33
TRUCK SCANIA 35
BIKE YAMAHA 54
BIKE YAMAHA 76
BIKE YAMAHA 43
BIKE YAMAHA 67
Labels (5)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Subfield() is here exactly for this purpose. Try like:

Load Type, Carname, SubField(Numberlist, ',')

From <...>;

View solution in original post

1 Reply
tresesco
MVP
MVP

Subfield() is here exactly for this purpose. Try like:

Load Type, Carname, SubField(Numberlist, ',')

From <...>;