Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Want to do it in script or on front end? what is the expected output you need?
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.
Script is also fine.
Need all the distinct values in a row with comma separation.
What you can do is use the concat function in script and then use that in chart or text box.
Regards,
Kaushik Solanki
Data:
LOAD FieldA,
FieldB,
Concat(distinct FieldC,',') as CommaSep
FROM table
group by FieldA,FieldB;
what is the purpose of showing huge value in same row..?
Thanks Kushal
This solved my issue.
Thanks to everyone else for the responses.