You’re offline. This is a read only version of the page.
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:
Share
Report
All responses (
Answers (
[
{
"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'))
#1
David_MA
385
Super User 2025 Season 1
#2
stampcoin
318
#3
Michael E. Gernaey
310
Super User 2025 Season 1
