Share
ReportHi,
I've been following the threads here related to filtering Array with another Array. I have two arrays and am trying to filter the 2nd larger Array (All) by the 1st smaller Array (Not Started). For my filter array, I'm using Array 2 as the "From", Array 1 on the left side and item()?['Name'] on the right side with the does not contain operator.
The objective is to have all Names in Array 2 matching the names in Array 1 filtered out, I.e. not appearing in the output.
Every time I run it no filtering occurs. I thought it was because there were duplicate names in both arrays so I used the union function to get unique values but that didn't have any effect.
Your thoughts are much appreciated!
Array 1 - Smaller Array with Status = "Not Started"
Array 2 - Larger array with Status is "Completed" And "Not Started"
Filter Array
All responses (
Answers (
124
