One way is to populate arrays for both company and country with the elements from the dereferenced array reference ($row->[0]: company name; $row->[1]: country name), and then use those arrays to create strings (values) that will be associated with company and country keys. The script, as a whole, would then look like this:

use Modern::Perl;
use WWW::Mechanize;
use HTML::TableExtract;

my ( %hash, @company, @country );

my $mech = WWW::Mechanize->new();
$mech->get('http://www.w3schools.com/sql/default.asp');
my $html_string = $mech->content();

my $te = HTML::TableExtract->new( headers => [ ( 'Company', 'Country' 
+) ] );
$te->parse($html_string);

for my $ts ( $te->tables ) {
    for my $row ( $ts->rows ) {
        push @company, qq|'$row->[0]'|;
        push @country, qq|'$row->[1]'|;
    }
}

$hash{'Company'} = '(' . ( join ', ', @company ) . ')';
$hash{'Country'} = '(' . ( join ', ', @country ) . ')';

say "$_ => $hash{$_}" for sort keys %hash

[download]

Output:

Company => ('Island Trading', 'Galería del gastrónomo', 'Laughing Bacc
+hus Wine Cellars', 'Paris spécialités', 'Simons bistro', 'Wolski Zaja
+zd')
Country => ('UK', 'Spain', 'Canada', 'France', 'Denmark', 'Poland')

[download]

In reply to Re^5: How to fetch table element from a site into data by Kenosis
in thread How to fetch table element from a site into data by Anonymous Monk

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.