Multiple identical dimension values
System dynamics program with additional features for economics
Brought to you by:
hpcoder,
profstevekeen
Menu
▾
▴
6 Attachments
#638 Multiple identical dimension values
I thought using Max or Average on importing this data would give me one entry per quarter. Instead I got 3, and I don't know how that's possible, given the insistence on unique dimension values.
Long story here, I'm trying to make up an example for a YouTube video and thought I'd include real GDP change as well as unemployment for a comparison. BIS data on inflation is monthly whereas the other 2 series are quarterly. The Inflation file is a Ravel output from monthly to quarter, which can't be re-imported with unique values--but which still ends up having multiple values for one dimension value.
When I imported Inflation_{USA} with the average operation, I got one entry per quarter, as you'd expect.
If you've imported monthly values, and then you set the export format to %Y-Q%Q, then the output file will have 3 entries per quarter, so that explains how the csv file above was generated.
As to how you got to the .rvl file above, that takes some effort. One way, I imagine, is to import the above CSV file using the blank format, which imports the 4 quarters as Jan, Feb, Mar, Apr. Then if you specify the display format as %Y-Q%Q, you will get 3 entries for the first quarter, and one for the second.
Not sure there's a bug here, though!