sorting in Table

mh10

Hi,
I have column with vlaues

ABC 1
ABC 2
ABC 3
.
.
.
.
ABC 10

I have inserted group in table on this column. and i am looking to display group details in order as it is with above column values. so i put sort key on this column as ascending..

but it shows group details with

ABC 1
ABC 10

---

I WANT "ABC 10" group detail at last position
ABC 2
ABC 3
.
.
.
ABC9



Any suggestions?

averma

Hi mh10:
Sorting on strings is always done lexicographically, so ABC10 comes before ABC2. If you would like to present your data in a different manner you could do sorting on a new hidden column (Computed column) and assign it a value in a way that would put your data rows in the desired order.
See the attached example, I have created a new computed column (Column3) that is based on a extracted numerical value from a existing column(Column1). In the table I am sorting the rows based on the value of the new computed column. (Note:The design file expects the data file to be in C:temp directory.)

Hope this helps.
AV