Datewise status should sort in order

[rupaliqlik]

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

[antoniotiman]

Hi Rupali,

may be

Concat(DISTINCT NEW_VALUE,',',ROW_NUMBER) AS NEW_VALUE

Regards,

Antonio

[rupaliqlik]

Thanks 🙂