We have a pair of nodes internally at the moment at @Vernalis which will convert missingcells in collection columns to empty collections, and empty collections to missing cells. Tbh, I thought we had released them to the community already, but it looks like we havenāt. Let me know if you would like me to get them on our release list!
if I got you right then this is already possible using GroupBy node. Use Append elements method on your collection column. Of course make sure you do not group anything
It is not intuitive but can work until Steve does his job
Ah @ipazin , thatās a good idea⦠And it turns out the Column Aggregator also works, which may be more convenient when there are others columns and one does not want to ruin the rowIDs.
They are on our trunk (nightly) build now, under Community Nodes -> Vernalis -> Collections, along with a 3rd new node, āCollection Sizeā:
One slight caveat is that I have a problem uploading test cases to the build server this evening, so the new nodes are technically untested - I will put an announcement out on the Vernalis forum page when that is resolved, but they should work OK! (I just installed them on my PC at home and they work fine)
Also the āCollection Sizeā node is very useful! yes it is easy to make a Java snippet that does the same thing, but using a dedicated node is much more elegantā¦