You’re offline. This is a read only version of the page.
Announcements
Hi,
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
I got it working - I removed the ['Name'] from the item()?['Name'] and it worked!
Share
Report
All responses (
Answers (
525
