data transformation : Split column and duplicate rows

[vimalthehero]

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

[tresesco · Accepted solution]

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

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

From <...>;