Sorting Data Tables

Options
Jeff_182127
Jeff_182127 Posts: 21
edited November 2019 in Ideas

I would find it helpful to be able to sort data tables by specific columns (e.g. Run Date by oldest-to-newest), but this functionality currently isn't available in Catalytic (I'd have to export to Excel and then sort).

1
1 votes

Swept · Last Updated

Comments

  • Jozef_783863
    Jozef_783863 Posts: 331 admin
    Options

    Hi @Jeff_182127,

    Thank you for posting your product request!

    I noticed the Process start date column in Master data tables has ASC as the default sort order. So oldest-to-newest is the default order for this column.

    Tables: Sort rows
    https://help.catalytic.com/docs/tables-sort-rows/

    We have a Tables: Sorts rows action to order the rows in a data table by values in a column. I confirmed that my date and time column type sorted as expected using this action.

    Do you have a Tables: Sorts rows action that is not sorting a date and time column as expected? Please let me know at help@catalytic.com and I will be happy to investigate!

  • Jacob_154284
    Options

    Hi @Jeff_182127, to clarify are you referring to sorting static Imported Data Tables instead of sorting data tables in a pushbot? The list of available actions that @Jozef_783863 mentioned will meet your needs when using a pusbhot to sort a data table.