Try building a hash from the name/value elements within each resourceGroup. Example using XML::Twig

#!/usr/bin/perl
use strict;
use XML::Twig;

#time|resourceGroup name|LCONNFAIL|LLOSTCONN|LIDLETIMEOUT|SIPADDR|SIPP
+ORT
my @columns = ('resourceGroup',
'LCONNFAIL','LLOSTCONN','LIDLETIMEOUT','SIPADDR','SIPPORT');
my $time;
my %record = ();

# tag handler
my $twig = XML::Twig->new(   
  twig_handlers => 
   { 
     resourceGroup => \&resourceGroup,
     statistic     => \&statistic,
   },
  start_tag_handlers => {
     statRecord => sub { $time = $_[1]->att('time') }
  }   
);

# process file
print join '|','time',@columns;
print "\n";
$twig->parsefile( 'my_file.xml' );

sub resourceGroup {
  my ($t,$e) = @_;
  $record{'resourceGroup'} = $e->att('name');
  
  # print record
  print join "|",$time,map{$record{$_}}@columns;
  print "\n";
  $t->purge;
  %record = ();
}

sub statistic {
  my ($t,$e) = @_;
  my $name       = $e->first_child_text('name');
  $record{$name} = $e->first_child_text('value');
}

[download]
poj

In reply to Re: parse XML huge file using cpan modules by poj
in thread parse XML huge file using cpan modules by nicopelle

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.