{"action":"opened","issue":{"url":"https://api.github.com/repos/sksamuel/eel/issues/15","labels_url":"https://api.github.com/repos/sksamuel/eel/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/sksamuel/eel/issues/15/comments","events_url":"https://api.github.com/repos/sksamuel/eel/issues/15/events","html_url":"https://github.com/sksamuel/eel/issues/15","id":129112135,"number":15,"title":"Pivot capability","user":{"login":"Antwnis","id":3376244,"avatar_url":"https://avatars.githubusercontent.com/u/3376244?v=3","gravatar_id":"","url":"https://api.github.com/users/Antwnis","html_url":"https://github.com/Antwnis","followers_url":"https://api.github.com/users/Antwnis/followers","following_url":"https://api.github.com/users/Antwnis/following{/other_user}","gists_url":"https://api.github.com/users/Antwnis/gists{/gist_id}","starred_url":"https://api.github.com/users/Antwnis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Antwnis/subscriptions","organizations_url":"https://api.github.com/users/Antwnis/orgs","repos_url":"https://api.github.com/users/Antwnis/repos","events_url":"https://api.github.com/users/Antwnis/events{/privacy}","received_events_url":"https://api.github.com/users/Antwnis/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-01-27T11:11:58Z","updated_at":"2016-01-27T11:11:58Z","closed_at":null,"body":"Imagine you have a schema : *quarter - product - sales* with data\r\n\r\n    (\"quarter1\",  \"wine\",   100)\r\n    (\"quarter1\",  \"beer\",   220)\r\n    (\"quarter1\",  \"coffee\", 550)\r\n    (\"quarter2\",  \"coffee\", 5)\r\n\r\nAnd you want to pivot by *product* and *sales* - with newschema = \"wine\" , \"beer\" , \"coffee\" defaultvalue=0 resulting into data\r\n\r\nquarter      wine     beer   coffee\r\nquarter1      100     220      0\r\nquarter2          0         0      5\r\n\r\nAlso be able to unpivot the data"}}