topic splitting the comma seperated value into multiple rows in QlikView

splitting the comma seperated value into multiple rows

Mon, 16 Apr 2012 07:40:38 GMT

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 — Mon, 16 Apr 2012 07:48:09 GMT

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 — Mon, 16 Apr 2012 08:08:00 GMT

Hi,

Use this script

TableName:

LOAD Manager,

SubField(Employee, ',') AS Employee

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards,

Jagan.

rajni_batra — Tue, 11 Dec 2012 10:33:41 GMT

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 — Tue, 11 Dec 2012 10:34:38 GMT

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 — Wed, 12 Dec 2012 13:01:03 GMT

Hi,

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

Regards,

Jagan.