|
 Transformation of csv-data to datasets |
| Posted by Sinan on Feb-28-2013 05:47 |
|
Hi,
I have problems to understand how to break down plain csv data as into datasets and datagroups to achieve specific groupings in the chart.
With the following data I would like to generate the chart further below.
Can you please give a hint?
Date System Currency Book Book Value1 Value2 Positions
2012-12-31 System1 USD BOOK1 100 150 4
2012-12-31 System1 USD BOOK2 200 210 3
2012-12-31 System1 EUR BOOK1 190 222 2
2012-12-31 System1 JPY BOOK1 412 522 1
2012-12-31 System1 JPY BOOK3 140 150 3
2012-12-31 System1 JPY BOOK4 190 120 4
2013-01-31 System1 USD BOOK1 300 320 5
2013-01-31 System1 GBP BOOK2 150 200 6
2013-01-31 System1 EUR BOOK3 210 300 4
2013-01-31 System1 JPY BOOK1 210 400 2
2013-01-31 System1 JPY BOOK2 60 90 1
2012-12-31 System2 RUB BOOK1 100 150 3
2012-12-31 System2 RUB BOOK2 222 231 4
2012-12-31 System2 EUR BOOK1 142 166 1
2012-12-31 System2 JPY BOOK1 321 232 3
2012-12-31 System2 EUR BOOK3 421 123 4
2012-12-31 System2 JPY BOOK4 231 421 1
2013-01-31 System2 GBP BOOK1 300 320 3
2013-01-31 System2 GBP BOOK2 150 200 4
2013-01-31 System2 EUR BOOK3 210 300 5
2013-01-31 System2 JPY BOOK1 210 400 2
2013-01-31 System2 JPY BOOK2 60 90 6
|
| Re: Transformation of csv-data to datasets |
| Posted by sinan on Feb-28-2013 07:38 |
|
Hi Peter,
never mind this question - I found a post with an example dualxlayers.pl which shows how the target arrays have to be setup - perfect as allways.
thank you
Sinan |
|
Forum Home
Search
Message List
Post Message
(Sinan) 