Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Sorting of alphanumeric column in Matrix table

Hi Team,  I am trying to sort alphanumeric column but its not working as expected.  its appearing as  1,10,11,12,2,3........I want in numerical order. I tried by spliting numeric part as separate ...
Need Help
audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
1 year ago

Hi! You can create a dim table to hold you're sorting order. Just put your sprints in one column and the sorting order in another. Then join to your table on sprint, but make sure you have sprint from the dim table sorted by the sort order column.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    audreygerred   I can create dim tabel but Sprint can be of any numbers so I cant define specific number of sprint in one column.. It shoudl work dynamically for any number of Sprint...Plz advise if it can work for dynamically