Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please mark the question as helpful and correct to close this thread.