{"action":"closed","issue":{"url":"https://api.github.com/repos/bazaarvoice/jolt/issues/190","repository_url":"https://api.github.com/repos/bazaarvoice/jolt","labels_url":"https://api.github.com/repos/bazaarvoice/jolt/issues/190/labels{/name}","comments_url":"https://api.github.com/repos/bazaarvoice/jolt/issues/190/comments","events_url":"https://api.github.com/repos/bazaarvoice/jolt/issues/190/events","html_url":"https://github.com/bazaarvoice/jolt/issues/190","id":139679561,"number":190,"title":"transformation help","user":{"login":"ergener","id":15010986,"avatar_url":"https://avatars.githubusercontent.com/u/15010986?v=3","gravatar_id":"","url":"https://api.github.com/users/ergener","html_url":"https://github.com/ergener","followers_url":"https://api.github.com/users/ergener/followers","following_url":"https://api.github.com/users/ergener/following{/other_user}","gists_url":"https://api.github.com/users/ergener/gists{/gist_id}","starred_url":"https://api.github.com/users/ergener/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ergener/subscriptions","organizations_url":"https://api.github.com/users/ergener/orgs","repos_url":"https://api.github.com/users/ergener/repos","events_url":"https://api.github.com/users/ergener/events{/privacy}","received_events_url":"https://api.github.com/users/ergener/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-03-09T19:39:21Z","updated_at":"2016-03-21T17:05:31Z","closed_at":"2016-03-21T17:05:31Z","body":"I am trying to do two transformations from the same input below and having a hard time figuring out the spec syntax.\r\n\r\ninput:\r\n```\r\n{\r\n   \"dataset\":{\r\n      \"id\":9775718,\r\n      \"dataset_code\":\"GOOG\",\r\n      \"database_code\":\"WIKI\",\r\n      \"name\":\"Alphabet Inc (GOOG) Prices, Dividends, Splits and Trading Volume\",\r\n      \"description\":\"End of day open, high, low, close and volume, dividends and splits, and split/dividend adjusted open, high, low close and volume for Google Inc. (GOOG). Ex-Dividend is non-zero on ex-dividend dates. Split Ratio is 1 on non-split dates. Adjusted prices are calculated per CRSP (www.crsp.com/products/documentation/crsp-calculations)\\n\\nThis data is in the public domain. You may copy, distribute, disseminate or include the data in other products for commercial and/or noncommercial purposes.\\n\\nThis data is part of Quandl's Wiki initiative to get financial data permanently into the public domain. Quandl relies on users like you to flag errors and provide data where data is wrong or missing. Get involved: connect@quandl.com\\n\",\r\n      \"refreshed_at\":\"2016-03-08T23:05:26.155Z\",\r\n      \"newest_available_date\":\"2016-03-08\",\r\n      \"oldest_available_date\":\"2014-03-27\",\r\n      \"column_names\":[\r\n         \"Date\",\r\n         \"Open\",\r\n         \"High\",\r\n         \"Low\",\r\n         \"Close\",\r\n         \"Volume\",\r\n         \"Ex-Dividend\",\r\n         \"Split Ratio\",\r\n         \"Adj. Open\",\r\n         \"Adj. High\",\r\n         \"Adj. Low\",\r\n         \"Adj. Close\",\r\n         \"Adj. Volume\"\r\n      ],\r\n      \"frequency\":\"daily\",\r\n      \"type\":\"Time Series\",\r\n      \"premium\":false,\r\n      \"limit\":null,\r\n      \"transform\":null,\r\n      \"column_index\":null,\r\n      \"start_date\":\"2014-03-27\",\r\n      \"end_date\":\"2016-03-08\",\r\n      \"data\":[\r\n         [\r\n            \"2016-03-08\",\r\n            688.59,\r\n            703.79,\r\n            685.34,\r\n            693.97,\r\n            2058471.0,\r\n            0.0,\r\n            1.0,\r\n            688.59,\r\n            703.79,\r\n            685.34,\r\n            693.97,\r\n            2058471.0\r\n         ],\r\n         [\r\n            \"2016-03-07\",\r\n            706.9,\r\n            708.0912,\r\n            686.9,\r\n            695.16,\r\n            2966800.0,\r\n            0.0,\r\n            1.0,\r\n            706.9,\r\n            708.0912,\r\n            686.9,\r\n            695.16,\r\n            2966800.0\r\n         ]\r\n      ],\r\n      \"collapse\":null,\r\n      \"order\":\"desc\",\r\n      \"database_id\":4922\r\n   }\r\n}\r\n```\r\n\r\nOutput 1. Transform the data array into name value pairs as seen below and I seem to not be able to figure out the spec for it. Is there an example that can help me?\r\n```\r\n[\r\n   {\r\n      \"date\":\"2016-03-08\",\r\n      \"open\":688.59,\r\n      \"high\":703.79,\r\n      \"low\":685.34,\r\n      \"close\":693.97,\r\n      \"volume\":2058471\r\n   },\r\n   {\r\n      \"date\":\"2016-03-07\",\r\n      \"open\":706.9,\r\n      \"high\":708.0912,\r\n      \"low\":686.9,\r\n      \"close\":695.16,\r\n      \"volume\":2966800\r\n   }\r\n]`\r\n```\r\n\r\nOutput 2. Transform same input to array, where with input array index is followed by the close price data[4] per data entry , as :\r\n```\r\n[  \r\n   [  \r\n      0,\r\n      693.97\r\n   ],\r\n   [  \r\n      1,\r\n      695.16\r\n   ]\r\n]\r\n```\r\n\r\nAny guidance would be appreciated.."}}