LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  How can I sort my columns from left to right?

    Employee
    Posted 11-12-2014 17:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: johnvvu

    I have column titles with the format yyyy-mm-dd and these dates change daily. How can sort the dates from left to right without manually emitting them in the order that I want?

    Thank you,


  • 2.  RE: How can I sort my columns from left to right?

    Employee
    Posted 11-12-2014 18:31

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    I'm not sure what your end goal is, but often times when the columns are dates, it helps to pivot (use Pivot Names to Data) so that each date becomes a record.

    But if you do want to re-arrange the order of the columns, I would use the Change Metadata node. I first use the Data Analyzer to pull in the field names. The field names are then split into two groups - those that have the CCYY-M-D format and those that don't. The ones with the CCYY-M-D format is then sorted, then merged with the rest. The result can then be used as an input to the Change Metadata node.
    Attachments:
    reorderColumns.brg