Feature suggestion: List/set operators

Hi

I would appreciate it if there were nodes operating on set/lists.

  • Analogously to the Insert into List node, where one can insert String columns into a list column, one that inserts collections into other collections. E.g. inserting at the second position:
    | Collection 1 | Collections 2 | Resulting Collection |
    | ------------ | ------------- | -------------------- |
    | ["E1","E4"] | ["E2","E3"] | ["E1","E2","E3","E4"] |
  • A node that takes two collection columns applying set operations on them. E.g. union
    | Collection 1 | Collections 2 | Resulting Collection |
    | ------------ | ------------- | -------------------- |
    | ["E1","E4"] | ["E2","E3"] | ["E1","E4","E2","E3"] |

Cheers

Thiemo

I think you can do both of thses with the Column Aggregator node

Steve

Hi @s.roughley

Thanks for the hint. However, I do not think, it does what I intend to.