How to nest values in a list from multiple rows in dremio

1

I am trying to create a list of products carried by customers.

I want to convert

|Cust Nbr|Products|
|12345|ABC|
|12345|BCD|
|12345|CEF|

to

|Cust Nbr|Product|
|12345|ABC, BCD, CEF|

Any ideas?

2

@ishan

Currently, there is no single function that Dremio offers to achieve your end result

3

Any way to create a custom function?

4

@ishan

Yes, you can create a UDF and use it

Here is an example GitHub - jacques-n/dremio-udf-example