topic Help in table script in QlikView

Help in table script

Wed, 17 Apr 2013 12:30:52 GMT

Hello,

Want a help,

In center no i have data like'1','2','3','4','5' against 1 employee_no 1

How can i split these center_no for coressponding employee_no as follows-

I want the center no. in the below format

center no. employee_no

1 1

2 1

3 1

4 1

5 1

and that needs to be linked to appropriate employee no.

So the relation will be

for employee no 1 -->center no -->1

Thanks and Regards

Priya

Gysbert_Wassenaar — Wed, 17 Apr 2013 16:59:34 GMT

See attached qvw. Is that what you need?

eddysanchez — Wed, 17 Apr 2013 17:13:20 GMT

I think you need to load your first table like:

Directory;

CenterTable:

LOAD SubField(Replace([Center No],Chr(39),''),',') as [Center No],

Employee_No

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);