Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 3 excel file data1, data2, and data3 in which there are 2 column EmpId and EmpName.
so how can i import data from these 3 file in a single load statement.......
Hi,
Let say you have 3 files names as
File1.xls
File2.xls
File3.xls
Then try below
load *
From file*.xls;
Regards
ASHFAQ
Hi
Try like this
Load * from data*.xls;
or
for each i in 'YYY.xlsx', 'XXX.xlsx'
LOAD Student,
field,
Note
FROM
$(i)
(ooxml, embedded labels, table is Feuil1);
Next
What type of file you have?