I know there is a mechanism by which to nest rows. That is, to package up a set of columns into a single ‘tuple valued’ column, such that they can be unpacked later. In effect, a DataCell containing a value of type DataRow.
Is there anything comparable for tables? Is there a way to package up tables to fit inside a single column? In effect, a DataCell containing a value of type DataTable?
If not, any suggestions how to go about it?
Why? This is a Relational Algebra approach to aggregation (grouping and summing).
There is currently no native table cell, however you can use the Table to JSON node to create a JSON cell which you can unpack into a table again using the JSON to Table node.
I have been looking at JSON as well, but when I convert a table to JSON Doubles get converted to strings, am I right? Not ideal when I have a lot of Doubles.
It’s not just doubles, JSON encodes everything as string, so if that’s a problem for you, keep looking. BJSON is a possibility, but the usual methods for serialisation are probably the best choice.