5 Replies Latest reply: Sep 20, 2012 6:36 AM by nineworks RSS

    Table Merging In Script

      I'm loading data into my solution as in the below:

       

      // Status table

      Status:

      Load * Inline

      [Category

      In Progress

      Awaiting Initial Audit Check

      Awaiting Start Date

      Start Date Arranged - Contract to be issued

      Awaiting Signed Contract

      Awaiting Final Audit Check

      Awaiting Signed Tracking Form

      Complete

      On Hold / Withdrawn];

       

      // Overview Table

      CorporateOverview:

      LOAD

                [Business Unit],

                [In Progress],

                [Awaiting Initial Audit Check],

                [Awaiting Start Date],

                [Start Date Arranged - Contract to be issued],

                [Awaiting Signed Contract],

                [Awaiting Final Audit Check],

                [Awaiting Signed Tracking Form],

                [Complete],

                [On Hold / Withdrawn],

                [Total]

      FROM $(vSpreadName)  (ooxml, embedded labels, table is 'Some Name'')

      where RowNo()<12;

       

      Once I've got the data, is it possible to create a new table with something like the below:

      Business Unit      StatusType          Value

      1                         In Progress          50

      1                         Complete             20

      etc

       

      This would give me the axes I need to draw a graph I'm struggling to create at the minute.

       

      Thanks