splitting the comma seperated value into multiple rows

[#1]

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

[adhudson · Accepted solution]

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]

Hi,

Use this script

TableName:

LOAD Manager,

     SubField(Employee, ',') AS Employee

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards,

Jagan.

[rajni_batra]

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]

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]

Hi,

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

Regards,

Jagan.