How can i fetch only error related fields and tables information from log file?

[#1]

Hi ,

Here I am attaching a sample log file and Sampleapp.qvw. And from this I need to fetch only error related fields and table information(field names and table name having error).and require to save that fields and table information into one table and save it into qvd format lastly.

Please help me out to solve this problem.

Regards,

Vasudha

[datanibbler]

Hi vasudha,

that's not exactly an easy one.

You can load the log_file into QlikView and parse it for the keyword "Error". If there is more than one instance of that, select the last one (using the timestamp or a rowNo() function).

When you have the rowNo(), you can load resident from that the ´part above the last ERROR (FIRST n LOAD).

I guess then you'll have to look for the last LOAD (the start of one, keyword) before any ERROR and extract the information about that.

HTH

Best regards,

DataNibbler

[sudeepkm]

maybe you can catch the errors in the script itself and store it in to a table. you are already using ErrorMode = 0; so after each load you can have a check to see if there are any errors present or not. take a look at the error variables in QV help to get more clarity.

[#4]

Hi Sudeep,

Thanks for reply.

Can you explain the anwer with any example?.It would be much easier to understand.

Regards,

Vasudha

[sudeepkm]

Please check this post.

A file checker utility for file based data sources

[#6]

Hi Sudeep,

Can you please let me know how can i do the same as above without creating Fieldlist field in the tables.Because  i have pre formatted excel files and i can not change their format.So plaese let know way to achieve the above.

Regards,

vasudha

[sudeepkm]

I've attached a sample with data. This should work for you. Let me know if you face any difficulties.