JSON_Name
Last
JSON_Name
Split Name column by . or _
,
Crosstab
FirstRow
Warn
Set first row as column names
(Left([JSON_Name],6)=="column")||(Left([JSON_Name],4)=="data")
Custom
Filter out unwanted rows
(Left([JSON_Name],6)=="column")||(Left([JSON_Name],4)=="data")
Sort decending by date
0 - Descending
C:\Users\ILYASI~1\AppData\Local\Temp\Engine_5160_3de5ea3f629540ae915a49622c5ceccc_\Engine_5852_cd534b64e5b241eea8420031c86d26a9_.yxdb
Single
Profile
Remove Name column
Input
http://www.quandl.com/api/v1/datasets/DISASTERCENTER/RATES.json?&trim_start=1960-12-31&trim_end=2012-12-31&sort_order=desc
C:\Users\ILYASI~1\AppData\Local\Temp\Engine_5160_3de5ea3f629540ae915a49622c5ceccc_\Engine_5852_e72d8d4006a64f6ca863f6c467128a71_.yxdb
Single
Profile
Field1
String
65001
GET
Compose
2
600
Download
DownloadData
Parse JSON
Horizontal
challenge_7_Iyoob