Just a guess...

#!/usr/bin/perl use strict; # https://perlmonks.org/?node_id=11129561 use warnings; my %hash; while( <DATA> ) { my ($one, $two, $three) = split /\s{2,}|\n/; $hash{$one}{$two}{$three}++; } for my $value ( values %hash ) { $_ = [ sort keys %$_ ] for values %$value; } use Data::Dump 'dd'; dd \%hash; __DATA__ 900000001 Network1 Login 900000002 Network1 2019-11-07T20:31:10.000Z 900000002 Network1 2021-02-19T13:47:25.000Z 900000002 Network1 2021-03-10T13:58:50.000Z 900000003 No Network1 NOT Registered 900000004 Network1 Login 900000005 Network1 Login 900000006 Network1 Login2 900000007 Network1 2021-03-10T17:11:24.000Z 900000007 Network1 2021-02-18T08:34:58.000Z 900000007 Network1 2021-01-25T17:19:44.000Z 500000008 Network1 2021-03-10T17:11:24.000Z 500000008 Network2 Not Used 500000008 Network1 2021-03-11T17:12:42.000Z 500000008 Network3 Not Used 400000008 Network1 2021-01-25T17:19:36.000Z

Outputs:

{ 400000008 => { Network1 => ["2021-01-25T17:19:36.000Z"] }, 500000008 => { Network1 => ["2021-03-10T17:11:24.000Z", "2021-03-11T +17:12:42.000Z"], Network2 => ["Not Used"], Network3 => ["Not Used"], }, 900000001 => { Network1 => ["Login"] }, 900000002 => { Network1 => [ "2019-11-07T20:31:10.000Z", "2021-02-19T13:47:25.000Z", "2021-03-10T13:58:50.000Z", ], }, 900000003 => { "No Network1" => ["NOT Registered"] }, 900000004 => { Network1 => ["Login"] }, 900000005 => { Network1 => ["Login"] }, 900000006 => { Network1 => ["Login2"] }, 900000007 => { Network1 => [ "2021-01-25T17:19:44.000Z", "2021-02-18T08:34:58.000Z", "2021-03-10T17:11:24.000Z", ], }, }

In reply to Re: How i can create hash of arrays of hashes from my 3 arrays? by tybalt89
in thread How i can create hash of arrays of hashes from my 3 arrays? by chandantul

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.