Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
While making QVD files, I load from a lot of different excel files using a wildcard.
So for example files KPI_DATA_19WK01, KPI_DATA_19WK02, KPI_DATA_19WK03 , etc.
I would like to input a trace or other way of seeing which document it is loading at the moment.
Any suggetsions on how to solve this?
Attached an example screenshot, where i can't see if i'm half way or nearly finished with loading the excel files.
Hi ,
I hope trace keyword will help you , please go through below URL.
Regards
Mahaveer
Hi,
Thanks for your reply.
The script loads all the tables using a wildcard and concatenates them into 1 table.
As far as I can see I'm not allowed to use Trace within the script part from load to from; So using a trace I will only get a message after it has loaded & concatenated all 52 separate files.
regards Sam
example:
BaseData:
LOAD
*
FROM [lib://E new (samsung-els_s.hoebee)/EOC/WEDC/RawData/SEBNRAW20*.xlsx]
(ooxml, embedded labels, table is Sheet1);
Trace ----------Will it work-----------
only gives me the trace after all is loaded and concatenated, while i would want a message after each excel is done.