comment on

Lots of other people have already explained what the problem is ... however, in this particular case, it looks as if the data is denormalized, as there are two instances of the columns from 'TOTAL QUALITY' to 'EDITED'.

It looks to me as if the occurance of a blank header is a sign that the next grouping starts, but I can't be sure with only two groups.

From the looks of things, you're looking at records from a health department that tracks well water, and you have two tests per well. Unfortunately, without knowing what you're trying to do with this data, I can't really make any recomendation on how best to deal with it in a meaninful way.

In reply to Re: hash and array mismatch by jhourcle
in thread hash and array mismatch by dana

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Your skill will accomplish what the force of many cannot
	PerlMonks