Solution
Input
Output
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
Weekly Challenge #7
http://www.quandl.com/api/v1/datasets/DISASTERCENTER/RATES.json?&trim_start=1960-12-31&trim_end=2012-12-31&sort_order=desc
2012-12-31
3246.1
386.9
2859.2
4.7
26.9
112.9
242.3
670.2
1959.3
229.7
2011-12-31
3292.5
387.1
2905.4
4.7
27
113.9
241.5
701.3
1974.1
230
2010-12-31
3350.4
404.5
2945.9
4.8
27.7
119.3
252.8
701
2005.8
239.1
2009-12-31
3465.5
431.9
3036.1
5
29.1
133.1
264.7
717.7
2064.5
259.2
2008-12-31
3669
457.5
3211.5
5.4
29.7
145.7
276.7
732.1
2167
314.7
2007-12-31
3730.4
466.9
3263.5
5.6
30
147.6
283.8
722.5
2177.8
363.3
2006-12-31
3808.1
473.6
3334.5
5.7
30.9
149.4
287.5
729.4
2206.8
398.4
2005-12-31
3900.5
469
3431.5
5.6
31.8
140.8
290.8
726.9
2287.8
416.8
2004-12-31
3977.3
463.2
3514.1
5.5
32.4
136.7
288.6
730.3
2362.3
421.5
2003-12-31
4067
475.8
3591.2
5.7
32.3
142.5
295.4
741
2416.5
433.7
2002-12-31
4125
494.4
3630.6
5.6
33.1
146.1
309.5
747
2450.7
432.9
2001-12-31
4162.6
504.5
3658.1
5.6
31.8
148.5
318.6
741.8
2485.7
430.5
2000-12-31
4124.8
506.5
3618.3
5.5
32
145
324
728.8
2477.3
412.2
1999-12-31
4266.5
523
3743.6
5.7
32.8
150.1
334.3
770.4
2550.7
422.5
1998-12-31
4615.5
566.4
4049.1
6.3
34.4
165.2
360.5
862
2728.1
459
1997-12-31
4927.3
611
4316.3
6.8
35.9
186.1
382.1
919.6
2891.8
505.7
1996-12-31
5087.6
636.6
4451
7.4
36.3
201.9
390.9
945
2980.3
525.7
1995-12-31
5274.9
684.5
4591.3
8.2
37.1
220.9
418.3
987.1
3043.8
560.4
1994-12-31
5373.5
713.6
4660
9
39.3
237.7
427.6
1042
3026.7
591.3
1993-12-31
5484.4
746.8
4737.7
9.5
41.1
255.9
440.3
1099.2
3032.4
606.1
1992-12-31
5660.2
757.5
4902.7
9.3
42.8
263.6
441.8
1168.2
3103
631.5
1991-12-31
5897.8
758.1
5139.7
9.8
42.3
272.7
433.3
1252
3228.8
658.9
1990-12-31
5820.3
731.8
5088.5
9.4
41.2
257
424.1
1235.9
3194.8
657.8
1989-12-31
5741
663.1
5077.9
8.7
38.1
233
383.4
1276.3
3171.3
630.4
1988-12-31
5664.2
637.2
5027.1
8.4
37.6
220.9
370.2
1309.2
3134.9
582.9
1987-12-31
5550
609.7
4940.3
8.3
37.4
212.7
351.3
1329.6
3081.3
529.5
1986-12-31
5480.4
620.1
4881.8
8.6
38.1
226
347.4
1349.8
3022.1
509.8
1985-12-31
5207.1
556.6
4650.5
8
37.1
208.5
302.9
1287.3
2901.2
462
1984-12-31
5031.3
539.2
4492.1
7.9
35.7
205.4
290.2
1263.7
2791.3
437.1
1983-12-31
5175
537.7
4637.3
8.3
33.7
216.5
279.2
1337.7
2869
430.8
1982-12-31
5603.7
571.1
5032.5
9.1
34
238.9
289.1
1488.8
3084.9
458.9
1981-12-31
5858.2
594.3
5263.8
9.8
36
258.7
289.7
1649.5
3139.7
474.7
1980-12-31
5950
596.6
5353.3
10.2
36.8
251.1
298.5
1684.1
3167
502.2
1979-12-31
5565.5
548.9
5016.6
9.8
34.7
218.4
286
1511.9
2999.1
505.6
1978-12-31
5140.4
497.8
4642.5
9
31
195.8
262.1
1434.6
2747.4
460.5
1977-12-31
5077.6
475.9
4601.7
8.8
29.4
190.7
247
1419.8
2729.9
451.9
1976-12-31
5287.3
467.8
4819.5
8.7
26.6
199.3
233.2
1448.2
2921.3
450
1975-12-31
5298.5
487.8
4810.7
9.6
26.3
220.8
231.1
1532.1
2804.8
473.7
1974-12-31
4850.4
461.1
4389.3
9.8
26.2
209.3
215.8
1437.7
2489.5
462.2
1973-12-31
4154.4
417.4
3737
9.4
24.5
183.1
200.5
1222.5
2071.9
442.6
1972-12-31
3961.4
401
3560.4
9
22.5
180.7
188.8
1140.8
1993.6
426.1
1971-12-31
4164.7
396
3768.8
8.6
20.5
188
178.8
1163.5
2145.5
459.8
1970-12-31
3984.5
363.5
3621
7.9
18.7
172.1
164.8
1084.9
2079.3
456.8
1969-12-31
3680
328.7
3351.3
7.3
18.5
148.4
154.5
984.1
1930.9
436.2
1968-12-31
3370.2
298.4
3071.8
6.9
15.9
131.8
143.8
932.3
1746.6
393
1967-12-31
2989.7
253.2
2736.5
6.2
14
102.8
130.2
826.6
1575.8
334.1
1966-12-31
2670.8
220
2450.9
5.6
13.2
80.8
120.3
721
1442.9
286.9
1965-12-31
2449
200.2
2248.8
5.1
12.1
71.7
111.3
662.7
1329.3
256.8
1964-12-31
2388.1
190.6
2197.5
4.9
11.2
68.2
106.2
634.7
1315.5
247.4
1963-12-31
2180.3
168.2
2012.1
4.6
9.4
61.8
92.4
576.4
1219.1
216.6
1962-12-31
2019.8
162.3
1857.5
4.6
9.4
59.7
88.6
535.2
1124.8
197.4
1961-12-31
1906.1
158.1
1747.9
4.8
9.4
58.3
85.7
518.9
1045.4
183.6
1960-12-31
1887.2
160.9
1726.3
5.1
9.6
60.1
86.1
508.6
1034.7
183
C:\Users\koboyle\AppData\Local\Temp\Engine_13020_1d1183c71ade4ed684e1916394dfbb45_\Engine_12080_cb393c8376f24ee18cd0736e9db0688c_.yxdb
Single
Profile
C:\Users\koboyle\AppData\Local\Temp\Engine_13020_1d1183c71ade4ed684e1916394dfbb45_\Engine_12080_1a144d5f29f44dcfa16cd7a42c33d8db_.yxdb
Single
Profile
Field1
String
65001
GET
Compose
2
600
Download data from a quandl url to a text field.
DownloadData
Parse JSON data to type specific fields.
Simple
JSON_Name1
Contains
column
Contains([JSON_Name1],"column")
JSON_Name
Last
JSON_Name
Parse the JSON_Name field into its components.
Select the field code and the column header.
Contains([JSON_Name],"data")
AND [JSON_Name3] = "0"
Custom
Contains([JSON_Name],"data")
AND [JSON_Name3] = "0"
Custom
Filter the numeric data records.
Select the common fields plus the numeric data values.
Join the date with the data.
Join the column headers with the data.
Cross tab the columns.
Sort by Date - Descending
Date - Descending
Re-order the columns.
Horizontal
challenge_7_solution_KO