Load value from specific cells in Excel, apply to all data

[#1]

Hi,

I need to fecth the process date and time showing on top of the excel sheet, and then apply it to the other data.

Pls see example below, sample file attached.

Any ideas?

Regards,

Olle

[#2]

Hi Andu,

when testing your script alone, the LOAD crashes "Execution of script failed".

Any idea why? I appreciate your help!

Regards,

Olle

[#3]

Thanks for your contrubution Anand, however as I pointed out above (in anwer to Andu).

I need the Tab1 to be a concatenate load, which does not work with your approach. And neither can I load this first and the other tables after, since the other loads are similar (concatenate and joins etc).

Any I deas how to work around this?

[anbu1984]

No idea. Check this app