10 Replies Latest reply: Jan 26, 2018 1:25 AM by Petter Skjolden RSS

    How do I change the order of data items?

    和男 細谷

      Everyone

      Please tell me how to change the format of A to B

      I would like to convert data to display a monthly graph. How do I write a Load script?

       

      ■Format A

      Startdate  Location Num Task           period   Cost

      201408     Osaka      1  basic design        10     $1,000

      201506     Osaka      1  final design         6     $1,200

      201511     Osaka      1  Design supervision  12     ¥3,600

      201701     Nagoya     2  basic design         5       $250

      201706     Tokyo      3  Design supervision   5     $5,000

      201612     Osaka      4  basic design         4     $1,200

      201704     Osaka      4  final design         5    $10,000

       

       

      ■Format B

      date    Location  Numコード Task      Cost

      201408  Osaka   1     basic design   $100

      201409  Osaka   1     basic design   $100

      201410  Osaka   1     basic design   $100

      201411  Osaka   1     basic design   $100

      201412  Osaka   1     basic design   $100

      201501  Osaka   1     basic design   $100

      201502  Osaka   1     basic design   $100

      201503  Osaka   1     basic design   $100

      201504  Osaka   1     basic design   $100

      201505  Osaka   1     basic design   $100

      201506  Osaka   1     final design   $200

      201507  Osaka   1     final design   $200

      201508  Osaka   1     final design   $200

      201509  Osaka   1     final design   $200

      201510  Osaka   1     final design   $200

      201511  Osaka   1     final design   $200

      201512  Osaka   1     Design supervision   $300

      201601  Osaka   1     Design supervision   $300

      201602  Osaka   1     Design supervision   $300

      201603  Osaka   1     Design supervision   $300

      201604  Osaka   1     Design supervision   $300

      201605  Osaka   1     Design supervision   $300

      201606  Osaka   1     Design supervision   $300

      201607  Osaka   1     Design supervision   $300

      201608  Osaka   1     Design supervision   $300

      201609  Osaka   1     Design supervision   $300

      201610  Osaka   1     Design supervision   $300

      201611  Osaka   1     Design supervision   $300

      201701  Nagoya   2     basic design   $50

      201702  Nagoya   2     basic design   $50

      201703  Nagoya   2     basic design   $50

      201704  Nagoya   2     basic design   $50

      201705  Nagoya   2     basic design   $50

      201706  Tokyo   3     Design supervision   $1,000

      201707  Tokyo   3     Design supervision   $1,000

      201708  Tokyo   3     Design supervision   $1,000

      201709  Tokyo   3     Design supervision   $1,000

      201710  Tokyo   3     Design supervision   $1,000

      201612  Osaka   4     basic design   $300

      201701  Osaka   4     basic design   $300

      201702  Osaka   4     basic design   $300

      201703  Osaka   4     basic design   $300

      201704  Osaka   4     final design   $2,000

      201705  Osaka   4     final design   $2,000

      201706  Osaka   4     final design   $2,000

      201707  Osaka   4     final design   $2,000

      201708  Osaka   4     final design   $2,000