The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
Create index of Year-Month column - TIBCO Spotfire Community

Create index of Year-Month column

Last post Tue, Feb 19 2013 7:40 PM by Conradwg. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • Tue, Feb 19 2013 7:40 PM

    • Conradwg
    • Top 500 Contributor
    • Joined on Sat, Jan 12 2013
    • Posts 6

    Create index of Year-Month column

    I have a table that contains a column with dates (YYYY-MM). The table contains multiple rows that have the same date value. I need to create an index of the column where the oldest date is "1", next date is "2" and so on. I need all date values that are the same to carry the same index value. I know this can be done in a Pivot table then adding and ranking column. However, I would like to do it within the data table itself without a Pivoting the data.  Any recommendations?

    Filed under:
Page 1 of 1 (1 items)
┬ęCopyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center