Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Jiang,
This can be done...
please find the attachment..
Hope this helps..
-Sundar
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
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!
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?
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!