REMOVEALL
Syntax
Description
Removes all elements from one list that exist in a specified list or lists.
Examples
REMOVEALL(#Column1;#Column2)
Column1 | Column2 | REMOVEALL returns |
---|---|---|
[1, 2, 3, 4] | [3, 4, 5, 6] | [1, 2] |
[3, 4, 5, 6] | [1, 2, 3, 4] | [5, 6] |
[7, 2] | [7, 6, 5, 4] | [2] |
[243, 43, 12] | [243, 43, 993, 12] | [] |