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: 
Not applicable

splitting the comma seperated value into multiple rows

Hi,

Is it possible to split the comma seperated data into multiple rows?

for example

Employee field contains the comma seperated value like

Manager     Employee

M1             E1,E2,E3

and it needs to be seperated into multiple rows like

Manager   Employee

M1           E1

M1           E2

M1           E3

1 Solution

Accepted Solutions
adhudson
Creator II
Creator II

Hi,

     You can use subfield(Employee,',') in script which splits the employee field into multiple rows.

     This matches your exact need.

Regards

Andrew Hudson

View solution in original post

5 Replies
adhudson
Creator II
Creator II

Hi,

     You can use subfield(Employee,',') in script which splits the employee field into multiple rows.

     This matches your exact need.

Regards

Andrew Hudson

jagan
Luminary Alumni
Luminary Alumni

Hi,

Use this script

TableName:

LOAD Manager,

     SubField(Employee, ',') AS Employee

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards,

Jagan.

rajni_batra
Specialist
Specialist

Hi Jagan

i have tried the same fro my ticket no but this is multiplying my cost amount also.. how can i solve this

rajni_batra
Specialist
Specialist

Hi Jagan

i have tried the same fro my ticket no but this is multiplying my cost amount also.. how can i solve this

jagan
Luminary Alumni
Luminary Alumni

Hi,

I didn't get you.  Please come up with an example.

Regards,

Jagan.