Sorting in a concatenation.

[boorgura]

Hi Folks,

Is it possible to sort before concatenating a text field to show in a text box?

Now, it is getting concatenated in an alphabetical order.

[Miguel_Angel_Baeyens]

Hello Rocky,

You can do the following

Concat(Field, ',', DateField)

to sort by DateField or any other numeric sort field you have.

Hope that helps

[boorgura · Accepted solution]

Hi Miguel,

Thanks for your response. But, I need to sort it in load order.

Is it possible?

[Miguel_Angel_Baeyens]

Hello,

Create a field in load time with

RowNo() AS LoadOrder

And use it with the Concat function above.