Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to add several excel files as data sources. How do I do that?
I also want to be able to link them with the table ID, so that I can extract data from all the files at the same time. Just by having an ID number from the excel file. How do I do that?
Greatful for some help
Hi,
In script window you can add every single file by clicking on tablefile button and select the excel file.
This will autogenerate a script for you.
Now to link two tables you need to give same name to the fields through which you have to link those two tables. Just like below.
Table1:
Load
a,b,c
From abc.xls
Table2:
Load
p, q, r as c
from pqr.xls
Here you are linking Table1 and Table 2 by field name c and r respectively. Thus we renamed one field r to c. So that both the table links to each other.
Regards,
Kaushik Solanki
Hi,
In script window you can add every single file by clicking on tablefile button and select the excel file.
This will autogenerate a script for you.
Now to link two tables you need to give same name to the fields through which you have to link those two tables. Just like below.
Table1:
Load
a,b,c
From abc.xls
Table2:
Load
p, q, r as c
from pqr.xls
Here you are linking Table1 and Table 2 by field name c and r respectively. Thus we renamed one field r to c. So that both the table links to each other.
Regards,
Kaushik Solanki