#!/usr/bin/perl use warnings; use strict; use Data::Dumper; foreach my $row (@$data) { if ($row->{ 'status' } eq "houses") { my $name = $row->{ 'name' } || ''; my $ad1 = $row->{ 'Ad1' } || ''; my $town = $row->{ 'City' } || ''; my $zcode = $row->{ 'zCode' } || ''; push @{$data}, {new_name => $name, new_ad1 => $ad1, new_City => $town, new_z_code => $zcode}; } } print Dumper @$data;