Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can use subfield(Employee,',') in script which splits the employee field into multiple rows.
This matches your exact need.
Regards
Andrew Hudson
Hi,
You can use subfield(Employee,',') in script which splits the employee field into multiple rows.
This matches your exact need.
Regards
Andrew Hudson
Hi,
Use this script
TableName:
LOAD Manager,
SubField(Employee, ',') AS Employee
FROM
test.xlsx
(ooxml, embedded labels, table is Sheet1);
Regards,
Jagan.
Hi Jagan
i have tried the same fro my ticket no but this is multiplying my cost amount also.. how can i solve this
Hi Jagan
i have tried the same fro my ticket no but this is multiplying my cost amount also.. how can i solve this
Hi,
I didn't get you. Please come up with an example.
Regards,
Jagan.