Syntax
Description
Creates a list of all unique non-null values seen in a group (currently max. 1000 values are collected). The order of elements isn't stable when running on a cluster, because the elements for each group might be collected on different nodes. If the element order matters, provide an order by expression as a second (optional) argument. This could for example be a timestamp or ID column in your data set.
...
Then use the GROUPCONCAT(#RawData!Value;#RawData!Time_Stamp), and the result is a list ordered list ordered by the identifier in relation to the GROUPBY() column.
...
Info |
---|
This function returns a lista list. If you require a JSON represented as a string a string wrap this function in TOJSON (E.g., TOJSON(<function>(...)). |
...