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
Data:
LOAD FieldA,
FieldB,
Concat(distinct FieldC,',') as CommaSep
FROM table
group by FieldA,FieldB;
Try this.
Concat(FieldName,',')
Regards,
Kaushik Solanki
am not sure...
u can give coma for decimal and thousand..... it wil seperate comma.
It doesn't work for 100,000 records in my case.
yes it is working for all..
go to document properties > select nymber tab-->select ur Number fileds--->change to override---> follow above image
Hi,
I need the distinct values in the field together with a comma separator.
This is not my requirement actually.
Thanks for the reply.
For a distinct value you can out distinct keyword.
Concat(Distinct FieldName,',')
Regards,
Kaushik Solanki
Like this may be
Concat(Distinct fieldName,',')
Are you using this in text box or where?
Thanks
Kiran Kumar
as mentioned Kaushik use distinct function=
=Concat(Distinct Filedname,',')
I have total 106,081 distinct values.
I want all of them to come in a row with comma separation.
It doesn't happen as the records are huge.
Is there any other way?
Thanks
Rajat Arora