Need to aggregate data based on a specific field?

[GreeYoN]

Please

How could I aggregate a set of data based on a specific field in dremio.

Here my table:

And I want t get the following result:

Please I need your help and support ?

[GreeYoN]

In think that dremio do not accept such a function :

FOR XML PATH

[balaji.ramaswamy]

@GreeYoN That is correct, currently Dremio does not have a function to do this and is an open enhancement request