topic Re: How can i fetch only error related fields and tables information from log file? in QlikView

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

Mon, 21 Sep 2015 10:16:36 GMT

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

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

datanibbler — Mon, 21 Sep 2015 11:28:18 GMT

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

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

sudeepkm — Mon, 21 Sep 2015 12:10:40 GMT

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.

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

Mon, 21 Sep 2015 12:49:23 GMT

Hi Sudeep,

Thanks for reply.

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

Regards,

Vasudha

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

sudeepkm — Mon, 21 Sep 2015 12:54:57 GMT

Please check this post.

A file checker utility for file based data sources

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

Tue, 22 Sep 2015 09:07:06 GMT

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

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

sudeepkm — Wed, 23 Sep 2015 12:38:36 GMT

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