Get comma separated values of a field

[rajat2392]

Hi,

I have a field with number values. There are around 106,000 records in the table.

I want all the values in any object as comma separated.

Can anybody suggest me how to achieve it.

Thanks

Rajat Arora

[Kushal_Chawda]

Want to do it in script or on front end?  what is the expected output you need?

[rajat2392]

Text object is required.

I can manage in a straight table as well.

But this expression doesn't work with this huge set of record.

[rajat2392]

Script is also fine.

Need all the distinct values in a row with comma separation.

[kaushiknsolanki]

What you can do is use the concat function in script and then use that in chart or text box.

Regards,

Kaushik Solanki

[Kushal_Chawda · Accepted solution]

Data:

LOAD  FieldA,

             FieldB,

             Concat(distinct FieldC,',') as CommaSep

FROM table

group by FieldA,FieldB;

[Kushal_Chawda]

what is the purpose of showing huge value in same row..?

[rajat2392]

Thanks Kushal

This solved my issue.

Thanks to everyone else for the responses.