To handle hashes of arbitrary depth I proposed avoiding nested foreach loops using instead a recursive function in this earlier post Re: DBI's selectall_hashref and nested foreach loops