Is it possible to merge the output from the below filter actions into one array for additional filtering? I need to put the output of both into one array so I can remove duplicates returned in both actions.
Thanks!
@grantjenkinsThanks for your help...I think it got me on the right path. Much appreciated!
@grantjenkinsAs always, thanks for the swift response and great help.
That worked to combine the items into one, but for some reason it didn't get rid of the duplicates.
This was the output of the union:
[
{
"Row_Ref": "4",
"DNAT_RuleCollectionPriority": "\n600",
"DNAT_RuleCollectionName": "\nnat",
"DNAT_RuleName": "\nib-test-udp-75",
"DNAT_Source": "\n*",
"DNAT_Port": "\n75",
"DNAT_Protocol": "\nUDP",
"DNAT_Destination": "\nxx.xxx.xxx.59",
"DNAT_TranslatedAddress": "\nxx.xxx.1.6",
"DNAT_TranslatedPort": "\n75",
"DNAT_Action": "\nDnat",
"DNAT_DestinationFQDNs": "\n",
"DNAT_DestinationIPGroups": "\n"
},
{
"Row_Ref": "4",
"DNAT_RuleCollectionPriority": "\n600",
"DNAT_RuleCollectionName": "\nnat",
"DNAT_RuleName": "\nib-test-udp-75",
"DNAT_Source": "\n*",
"DNAT_Port": "\n75",
"DNAT_Protocol": "\nUDP",
"DNAT_Destination": "\nxx.xxx.xxx.59",
"DNAT_TranslatedAddress": "\nxx.xxx.1.6",
"DNAT_TranslatedPort": "\n75",
"DNAT_Action": "\nDnat",
"DNAT_DestinationFQDNs": "\n",
"DNAT_DestinationIPGroups": "\n"
},
{
"Row_Ref": "15",
"DNAT_RuleCollectionPriority": "\n100",
"DNAT_RuleCollectionName": "\nnat",
"DNAT_RuleName": "\nib-thisisatest-tcp-447",
"DNAT_Source": "\n*",
"DNAT_Port": "\n447",
"DNAT_Protocol": "\nTCP",
"DNAT_Destination": "\nxx.xxx.xxx.61",
"DNAT_TranslatedAddress": "\nxx.xxx.x.9",
"DNAT_TranslatedPort": "\n447",
"DNAT_Action": "\nDnat",
"DNAT_DestinationFQDNs": "\n",
"DNAT_DestinationIPGroups": "\n"
}
]
Is there any way to get rid of the duplicate item in the return format? As you can see the output has two inner blocks with the exact same data.
You can add the output from each of your Filter arrays into a union expression to combine them.
union(body('Filter_DNAT_array_1'), body('Filter_DNAT_array_2'))
stampcoin
99
Michael E. Gernaey
82
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1