topic Adding trace in loading block? in QlikView

Adding trace in loading block?

Mon, 23 Dec 2013 07:30:31 GMT

Hi QV experts,

I have a question. Is that possible to trace in a loading block? For example i have something like this:

MyTable:
Load
blah blah
From *_my_pattern_*.xlsx

This will load all excel files in one folder. Now my question is, when the loading encounters an error, it will fully stop and ask me to load the old data. I checked the log file, and it basically gives me a General Script Error, but doesn't tell me which file caused this problem. Hence is that possible to add a trace in the loading script? So that at least i can see which file stops the entire loading?

Thanks in advance!

Re: Adding trace in loading block?

sundarakumar — Mon, 23 Dec 2013 08:00:18 GMT

Hi Jiang,

This can be done...

please find the attachment..

Hope this helps..

-Sundar

Re: Adding trace in loading block?

ramkrishna86 — Mon, 23 Dec 2013 08:59:00 GMT

Hi Jiang Liu, You can use TRACE to display your load like the following:

TRACE 'Loading GLOBAL_DATA data...';

GLOBAL_DATA:

LOAD *

from [$(vGlobalDataFilePath)]

(ooxml, embedded labels, table is GLOBAL_DATA);

Ram krishna

Re: Adding trace in loading block?

Mon, 23 Dec 2013 09:00:19 GMT

Hi Sundar,

Thanks for your help! However in my scenario is, when a loading failed in the middle, the application stopped and i can only select to reload old data. If i can see which file has been loaded, then i can isolate good files in my source folder and then find out the error excel file(s).

Thanks again!

Re: Adding trace in loading block?

sundarakumar — Mon, 23 Dec 2013 09:13:24 GMT

Sorry Jiang i cannot understand what your requirement is, because while reloading it is already showing the file name after it has been fetched.. so that will will tell you the last file that got reloaded successfully... Can you please explain your requirement?

Re: Adding trace in loading block?

Mon, 23 Dec 2013 10:00:56 GMT

Hi Sundar,

The script failed during the middle of loading. And i have to click on "reload old data" to roll back to the old version. When i check log file, it says "General Script Error" and didn't tell me which file was actually causing the loading problem. Hence i want to add a trace in loading script to see which file is loading.

Thanks a lot!