Hi airtable!
I have a list (an array) of items in two columns. Each row represents two different lists (one in each column). I’d like to be able to compare the two columns and remove what is common in both. For example
Row 1:
Column 1: Apple, Orange, Pineapple, Kiwi
Column 2: Apple, Kiwi
Result: Column 3: Orange, Pineapple
Row 2:
Column 1: Banana, Orange, Grape, Kiwi, Pineapple, Passion Fruit
Column 2: Orange, Grape, Pineapple
Result: Column 3: Banana, Kiwi, Passion Fruit
etc.
The general functionality is to be able to compare (two or more arrays) and perform some kind of action.
Is this something that could be worked on?
Let me know if you’d like more details.
There are a few other posts here from people who have similar requests and ideas:
Removing specific values from arrays (this is mine in support)
Array intersect formula
Using Rollup to check on completed tasks?
... View more