Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can you please help me with below requirement.
I need to load the data from Multiple Sheet where there was date reported. Also i need to consider to made lt as incremental load based on the date on the sheet.
Please see the screen short of the excel sheet name.
Thanks,
Gowtham
Hi,
You can try this method,
In Load Script u use the codes below
LOAD
A,
B
FROM [lib://CONNECTION NAME/FILE.xlsx]
(ooxml, embedded labels, table is 15-06-2018);
LOAD
A,
B
FROM [lib://CONNECTION NAME/FILE.xlsx]
(ooxml, embedded labels, table is 16-06-2018);
Thanks