Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have one field In that the values are like A,O,E.....I want to see it as 'A','E','O'
How can i
Pls Suggest me
Thanks
try,
=Concat(DISTINCT chr(39)&YourField&chr(39),',')
Do you want it in alphabetic order? I would prefer do it inscript
tmpyourtable:
load
..
chr(39) & yourfield & chr(39) as yourfield
from ..
YourTable:
load *
resident tmpyourtable
order by yourfield asc; // you can skip asc as this is the Default order
drop table tmpyourtable
example script
x:
load chr(39)&value&chr(39) as value
Inline
[
value
A
O
E
];
Hi Please use as shown below.
Thanks For your response its working fine.