Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Expert,
I have Row ID wise NEW VALUE and REC UPDATED DATE .My user want data must be concat and show in one column with ascending order.I can sort date but New value can not sort.It automatically sort by alphabetically order.Please suggest correct way .I have attached sample data.
Thanks in advance.
Rupali
Hi Rupali,
may be
Concat(DISTINCT NEW_VALUE,',',ROW_NUMBER) AS NEW_VALUE
Regards,
Antonio
Thanks 🙂