Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
i have execl 10 execl files..but senario is all execl name is A but sheet name is diffrent
so how to fetch the all execl file at a time
thanks ®ards
rohit
try something like this
load *
FROM \A*.xls (biff, embedded labels);
hi Prasath,
that is i know
but in execl file sheet name is diffrent
like Sheet1,Sheet11....etc
thanks
rohit
Hi
have a look to this link http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html
it may help
Regards
Gilles