Check two ARRAYS for values [structure formula]

Toni Strauchfuss

Hello everyone,

I have an ARRAY with alphabetical values in a structure formula.
And I have a second ARRAY, also with alphabetical values. Both ARRAYs are sorted.

I want to output the values from the first ARRAY that are not contained in the second ARRAY.

Something like that:

WITH A = ARRAY("One","Two","Three") : 
WITH B = ARRAY("One","Three") : 

WITHOUT(A, 

result -> One, Two, Three
I expect -> Two

 

The WITHOUT function unfortunately only allows one value.
Is there any solution for my problem?

 

BR,

Toni

Stepan Kholodov

Hello @Toni Strauchfuss 

You can use a formula like this for comparing two arrays and returning the difference between them:

with Array1 = ARRAY(...):
with Array2 = ARRAY(...):
Array1.FILTER(x -> !Array2.CONTAINS(x)).JOIN(", ")

I hope this helps. If you need further assistance with the formula or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)