Re: Add new rows and data to array.

As in your previous question, I use grep to eliminate irrelevant data.

use strict;
use warnings;

use Data::Dumper;

my $data =[
... # Ref OP
];
my @extras  = grep {$_->{status} eq 'Extra'} @$data;
my @mains   = grep {$_->{status} eq 'Main' } @$data;
MAIN:
foreach my $main (@mains) {
    EXTRA:
    foreach my $extra (@extras) {
        next EXTRA if $main->{ID} ne $extra->{ID};
        @{$main}{qw/new_name new_ad1 new_city new_z_code/}
            = @{$extra}{qw/name Ad1 City zCode/};
        print Dumper($main);
        next MAIN;
    }
}
[download]

OUTPUT:

$VAR1 = {
          'ID' => '2222',
          'City' => 'NY',
          'zCode' => '0002',
          'Ad1' => '20 North Central St.',
          'name' => 'John D',
          'state' => 'TO',
          'new_z_code' => '0007',
          'new_ad1' => '100 main St.',
          'status' => 'Main',
          'new_city' => 'BO',
          'new_name' => 'Tony Star'
        };
$VAR1 = {
          'zCode' => '2334',
          'name' => 'Charles D',
          'Ad1' => '12th Street',
          'ID' => '1111',
          'City' => 'NM',
          'new_name' => 'Marie Doe',
          'status' => 'Main',
          'new_city' => 'MA',
          'new_z_code' => '9857',
          'state' => 'CA',
          'new_ad1' => '44 Dell St'
        };
[download]

Bill

Comment on Re: Add new rows and data to array. Select or Download Code

Replies are listed 'Best First'.
Re^2: Add new rows and data to array. by Anonymous Monk on Mar 19, 2020 at 21:35 UTC
Yes, but I also need the other "status = Main" with no Extra related: This one, I will have lots of data in that situation: `$VAR9 = { 'new_City' => '', 'ID' => '8888', 'status' => 'Main', 'name' => 'AKAKAK', 'City' => 'AA', 'state' => 'PP', 'new_ad1' => '', 'Ad1' => '1AAAA', 'new_z_code' => '', 'new_name' => '', 'zCode' => 'TTTT' };` [download]	[reply] [d/l]
Re^3: Add new rows and data to array. by BillKSmith (Monsignor) on Mar 19, 2020 at 22:21 UTC
The $data array is updated. Print any part you want. `...# As before my @extras = grep {$_->{status} eq 'Extra'} @$data; my @mains = grep {$_->{status} eq 'Main' } @$data; MAIN: foreach my $main (@mains) { EXTRA: foreach my $extra (@extras) { next EXTRA if $main->{ID} ne $extra->{ID}; @{$main}{qw/new_name new_ad1 new_city new_z_code/} = @{$extra}{qw/name Ad1 City zCode/}; } print Dumper($main); }` [download] OUTPUT: $VAR1 = { 'state' => 'TO', 'new_z_code' => '0007', 'zCode' => '0002', 'status' => 'Main', 'ID' => '2222', 'name' => 'John D', 'City' => 'NY', 'new_city' => 'BO', 'new_ad1' => '100 main St.', 'Ad1' => '20 North Central St.', 'new_name' => 'Tony Star' }; $VAR1 = { 'zCode' => '2334', 'status' => 'Main', 'ID' => '1111', 'state' => 'CA', 'new_z_code' => '9857', 'Ad1' => '12th Street', 'new_name' => 'Marie Doe', 'name' => 'Charles D', 'City' => 'NM', 'new_city' => 'MA', 'new_ad1' => '44 Dell St' }; $VAR1 = { 'City' => 'AA', 'name' => 'AKAKAK', 'state' => 'PP', 'ID' => '8888', 'Ad1' => '1AAAA', 'zCode' => 'TTTT', 'status' => 'Main' }; [download] Bill	[reply] [d/l] [select]
Re^4: Add new rows and data to array. by Anonymous Monk on Mar 19, 2020 at 22:36 UTC
Noticed that I still need to new rows, but empty because there is no status = extra related to that one : `$VAR9 = { 'new_City' => '', <<<<<<< 'ID' => '8888', 'status' => 'Main', 'name' => 'AKAKAK', 'City' => 'AA', 'state' => 'PP', 'new_ad1' => '', <<<<<<< 'Ad1' => '1AAAA', 'new_z_code' => '', <<<<<< 'new_name' => '', <<<<<< 'zCode' => 'TTTT' };` [download]	[reply] [d/l]
Re^5: Add new rows and data to array. by BillKSmith (Monsignor) on Mar 20, 2020 at 00:16 UTC
Re^4: Add new rows and data to array. by Anonymous Monk on Mar 21, 2020 at 02:44 UTC
Thank you, I am going to implement my code here now!!!	[reply]
Re^5: Add new rows and data to array. by BillKSmith (Monsignor) on Mar 21, 2020 at 14:38 UTC