Help in table script

[#1]

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

                                                  2

                                                  3

                                                  4

                                                  5

Thanks and Regards

Priya

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. Is that what you need?

[eddysanchez]

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);