topic How to extract this data in QlikView

How to extract this data

Tue, 03 Mar 2015 18:16:17 GMT

Hello all,

in attachment you can see the data from xml that tasks produce.

How can I get the data, so that I can create a chart showing the usage of cpu, ram etc?

Thanks in advance

Re: How to extract this data

maxgro — Tue, 03 Mar 2015 18:29:26 GMT

try Peter suggestion here

http://community.qlik.com/message/633876#633876

Re: How to extract this data

JonnyPoole — Tue, 03 Mar 2015 18:30:23 GMT

Hi there - have you tried the governance dashboard or systems monitor ? These utilities have already been built .

http://market.qlik.com/qlikview-governance-dashboard.html

QlikView Application: System Monitor v5.1.23

Re: How to extract this data

Tue, 03 Mar 2015 18:36:14 GMT

I need that info for my own application, so that will not work.

Re: How to extract this data

Thu, 05 Mar 2015 19:34:00 GMT

bump

Re: How to extract this data

anbu1984 — Fri, 06 Mar 2015 03:31:07 GMT

Can you post sample data and expected output

Re: How to extract this data

rwunderlich — Fri, 06 Mar 2015 03:38:04 GMT

Use the Table File wizard to generate the correct load statement.

-Rob

Re: How to extract this data

Fri, 06 Mar 2015 13:42:50 GMT

Hello Rob.

the answer is helpful, but do you know how to get data from multiple files.

When I use the wizard, it loads data within that specified range, and extracted data is like in attachment.

Can you help me?

Re: How to extract this data

rwunderlich — Fri, 06 Mar 2015 16:06:57 GMT

Please post your LOAD statement.

-Rob

Re: How to extract this data

Fri, 06 Mar 2015 16:10:05 GMT

Hello Rod, here it is:

LOAD @134:139,

@163:168,

FROM

[\\10.145.73.78\qlikview\QlikView_Server_Logs\DistributionService\REPO\TaskResults\TaskResult*.xml]

(fix, utf8, header is 3 lines, record is 7 lines);

Re: How to extract this data

rwunderlich — Fri, 06 Mar 2015 16:29:09 GMT

That is not an XML loading statement. When you are in the Table File wizard, make sure you have selected XML as the filetype as in this screenshot.

-Rob

Re: How to extract this data

Fri, 06 Mar 2015 16:38:31 GMT

Hello Rob,

I know that that is not xml load.

Could you then send me an example of script that divides the data as shown in the first post?

Basically I need table that looks like this:

Column = value

Peak Physical Ram = 32.55

Peak Cpu = 1.2

Peak Virtual ram = 90.81

and the data is stored in the logs like shown in the first attachment.

thanks in advance

Re: How to extract this data

rwunderlich — Fri, 06 Mar 2015 17:06:45 GMT

You will need to first load the XML. Then parse the data you want out of the Text fields probably using functions like TextBetween. See attached for XML script.

-Rob