Match values against two arrays

[Kjetil_Sandvik]

Hi!

I am struggling with a simple problem (hopefully)

This output from module “Set multiple variables” shows two arrays. I want to return in a new array only the values that matches. In this case there are two values that matches.

Any idea how to achieve this?

[Levin]

I can’t think of anything else that works without custom code. Besides iterating through an array and checking if the other array contains the value. I have made a simple example here.

blueprint (71).json (5.5 KB)

[Kjetil_Sandvik]

Thanks for replying. That confirms that I dont need to look for a formula or function that supports this. I also found this post which explains the same approach as you did:

How to compare two values in two arrays?

The following scenario will do the trick for you:​ [image] The “Set multiple variables” module is there to take the ids from the input, enclose them in separate arrays and compare them. The current value array is then split and each value (id) from there is considered only if it is contained inside the “previous value” array. The second route of the scenario does the exact opposite, i.e. the id is considered only if it is not inside the previous array. When setting up the filt…