Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Issue in Parsing Nested JSON

Chaks
6 - Meteoroid

 

[null,null,{"rows":[{"cells":[{"value":"3","formatted_value":"3"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"3","formatted_value":"3"},{"value":"0","formatted_value":"0"},{"value":"2","formatted_value":"2"},{"value":"4","formatted_value":"4"},{"value":"15","formatted_value":"15"},{"value":"5","formatted_value":"5"},{"value":"3","formatted_value":"3"},{"value":"3","formatted_value":"3"},{"value":"8","formatted_value":"8"},{"value":"4","formatted_value":"4"},{"value":"5","formatted_value":"5"},{"value":"0","formatted_value":"0"},{"value":"2","formatted_value":"2"},{"value":"3","formatted_value":"3"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"4","formatted_value":"4"},{"value":"4","formatted_value":"4"},{"value":"1","formatted_value":"1"},{"value":"3","formatted_value":"3"},{"value":"11","formatted_value":"11"},{"value":"2","formatted_value":"2"},{"value":"3","formatted_value":"3"},{"value":"3","formatted_value":"3"},{"value":"2","formatted_value":"2"},{"value":"0","formatted_value":"0"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"5","formatted_value":"5"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"4","formatted_value":"4"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"6","formatted_value":"6"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"3","formatted_value":"3"},{"value":"2","formatted_value":"2"},{"value":"3","formatted_value":"3"},{"value":"6","formatted_value":"6"},{"value":"5","formatted_value":"5"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"3","formatted_value":"3"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"2","formatted_value":"2"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"2","formatted_value":"2"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"5","formatted_value":"5"},{"value":"3","formatted_value":"3"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"5","formatted_value":"5"},{"value":"4","formatted_value":"4"},{"value":"2","formatted_value":"2"},{"value":"1","formatted_value":"1"},{"value":"5","formatted_value":"5"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"0","formatted_value":"0"},{"value":"0","formatted_value":"0"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"2","formatted_value":"2"},{"value":"5","formatted_value":"5"},{"value":"11","formatted_value":"11"},{"value":"2","formatted_value":"2"},{"value":"0","formatted_value":"0"},{"value":"1","formatted_value":"1"},{"value":"n/a"},{"value":"n/a"},{"value":"n/a"},{"value":"n/a"},{"value":"n/a"},{"value":"n/a"},{"value":"n/a"},{"value":"n/a"},{"value":"n/a"},{"value":"n/a"}],"label":"KKKK"}],"column_groups":[{"data_columns":[{"name":"1533074400000","name_formatted":"01/08/18 00:00:00","code":"1533074400000","type":"datetime"}]},{"data_columns":[{"name":"1533078000000","name_formatted":"01/08/18 01:00:00","code":"1533078000000","type":"datetime"}]},{"data_columns":[{"name":"1533081600000","name_formatted":"01/08/18 02:00:00","code":"1533081600000","type":"datetime"}]},{"data_columns":[{"name":"1533085200000","name_formatted":"01/08/18 03:00:00","code":"1533085200000","type":"datetime"}]},{"data_columns":[{"name":"1533088800000","name_formatted":"01/08/18 04:00:00","code":"1533088800000","type":"datetime"}]},{"data_columns":[{"name":"1533092400000","name_formatted":"01/08/18 05:00:00","code":"1533092400000","type":"datetime"}]},{"data_columns":[{"name":"1533096000000","name_formatted":"01/08/18 06:00:00","code":"1533096000000","type":"datetime"}]},{"data_columns":[{"name":"1533099600000","name_formatted":"01/08/18 07:00:00","code":"1533099600000","type":"datetime"}]},{"data_columns":[{"name":"1533103200000","name_formatted":"01/08/18 08:00:00","code":"1533103200000","type":"datetime"}]},{"data_columns":[{"name":"1533106800000","name_formatted":"01/08/18 09:00:00","code":"1533106800000","type":"datetime"}]},{"data_columns":[{"name":"1533110400000","name_formatted":"01/08/18 10:00:00","code":"1533110400000","type":"datetime"}]},{"data_columns":[{"name":"1533114000000","name_formatted":"01/08/18 11:00:00","code":"1533114000000","type":"datetime"}]},{"data_columns":[{"name":"1533117600000","name_formatted":"01/08/18 12:00:00","code":"1533117600000","type":"datetime"}]},{"data_columns":[{"name":"1533121200000","name_formatted":"01/08/18 13:00:00","code":"1533121200000","type":"datetime"}]},{"data_columns":[{"name":"1533124800000","name_formatted":"01/08/18 14:00:00","code":"1533124800000","type":"datetime"}]},{"data_columns":[{"name":"1533128400000","name_formatted":"01/08/18 15:00:00","code":"1533128400000","type":"datetime"}]},{"data_columns":[{"name":"1533132000000","name_formatted":"01/08/18 16:00:00","code":"1533132000000","type":"datetime"}]},{"data_columns":[{"name":"1533135600000","name_formatted":"01/08/18 17:00:00","code":"1533135600000","type":"datetime"}]},{"data_columns":[{"name":"1533139200000","name_formatted":"01/08/18 18:00:00","code":"1533139200000","type":"datetime"}]},{"data_columns":[{"name":"1533142800000","name_formatted":"01/08/18 19:00:00","code":"1533142800000","type":"datetime"}]},{"data_columns":[{"name":"1533146400000","name_formatted":"01/08/18 20:00:00","code":"1533146400000","type":"datetime"}]},{"data_columns":[{"name":"1533150000000","name_formatted":"01/08/18 21:00:00","code":"1533150000000","type":"datetime"}]},{"data_columns":[{"name":"1533153600000","name_formatted":"01/08/18 22:00:00","code":"1533153600000","type":"datetime"}]},{"data_columns":[{"name":"1533157200000","name_formatted":"01/08/18 23:00:00","code":"1533157200000","type":"datetime"}]},{"data_columns":[{"name":"1533160800000","name_formatted":"02/08/18 00:00:00","code":"1533160800000","type":"datetime"}]},{"data_columns":[{"name":"1533164400000","name_formatted":"02/08/18 01:00:00","code":"1533164400000","type":"datetime"}]},{"data_columns":[{"name":"1533168000000","name_formatted":"02/08/18 02:00:00","code":"1533168000000","type":"datetime"}]},{"data_columns":[{"name":"1533171600000","name_formatted":"02/08/18 03:00:00","code":"1533171600000","type":"datetime"}]},{"data_columns":[{"name":"1533175200000","name_formatted":"02/08/18 04:00:00","code":"1533175200000","type":"datetime"}]},{"data_columns":[{"name":"1533178800000","name_formatted":"02/08/18 05:00:00","code":"1533178800000","type":"datetime"}]},{"data_columns":[{"name":"1533182400000","name_formatted":"02/08/18 06:00:00","code":"1533182400000","type":"datetime"}]},{"data_columns":[{"name":"1533186000000","name_formatted":"02/08/18 07:00:00","code":"1533186000000","type":"datetime"}]},{"data_columns":[{"name":"1533189600000","name_formatted":"02/08/18 08:00:00","code":"1533189600000","type":"datetime"}]},{"data_columns":[{"name":"1533193200000","name_formatted":"02/08/18 09:00:00","code":"1533193200000","type":"datetime"}]},{"data_columns":[{"name":"1533196800000","name_formatted":"02/08/18 10:00:00","code":"1533196800000","type":"datetime"}]},{"data_columns":[{"name":"1533200400000","name_formatted":"02/08/18 11:00:00","code":"1533200400000","type":"datetime"}]},{"data_columns":[{"name":"1533204000000","name_formatted":"02/08/18 12:00:00","code":"1533204000000","type":"datetime"}]},{"data_columns":[{"name":"1533207600000","name_formatted":"02/08/18 13:00:00","code":"1533207600000","type":"datetime"}]},{"data_columns":[{"name":"1533211200000","name_formatted":"02/08/18 14:00:00","code":"1533211200000","type":"datetime"}]},{"data_columns":[{"name":"1533214800000","name_formatted":"02/08/18 15:00:00","code":"1533214800000","type":"datetime"}]},{"data_columns":[{"name":"1533218400000","name_formatted":"02/08/18 16:00:00","code":"1533218400000","type":"datetime"}]},{"data_columns":[{"name":"1533222000000","name_formatted":"02/08/18 17:00:00","code":"1533222000000","type":"datetime"}]},{"data_columns":[{"name":"1533225600000","name_formatted":"02/08/18 18:00:00","code":"1533225600000","type":"datetime"}]},{"data_columns":[{"name":"1533229200000","name_formatted":"02/08/18 19:00:00","code":"1533229200000","type":"datetime"}]},{"data_columns":[{"name":"1533232800000","name_formatted":"02/08/18 20:00:00","code":"1533232800000","type":"datetime"}]},{"data_columns":[{"name":"1533236400000","name_formatted":"02/08/18 21:00:00","code":"1533236400000","type":"datetime"}]},{"data_columns":[{"name":"1533240000000","name_formatted":"02/08/18 22:00:00","code":"1533240000000","type":"datetime"}]},{"data_columns":[{"name":"1533243600000","name_formatted":"02/08/18 23:00:00","code":"1533243600000","type":"datetime"}]},{"data_columns":[{"name":"1533247200000","name_formatted":"03/08/18 00:00:00","code":"1533247200000","type":"datetime"}]},{"data_columns":[{"name":"1533250800000","name_formatted":"03/08/18 01:00:00","code":"1533250800000","type":"datetime"}]},{"data_columns":[{"name":"1533254400000","name_formatted":"03/08/18 02:00:00","code":"1533254400000","type":"datetime"}]},{"data_columns":[{"name":"1533258000000","name_formatted":"03/08/18 03:00:00","code":"1533258000000","type":"datetime"}]},{"data_columns":[{"name":"1533261600000","name_formatted":"03/08/18 04:00:00","code":"1533261600000","type":"datetime"}]},{"data_columns":[{"name":"1533265200000","name_formatted":"03/08/18 05:00:00","code":"1533265200000","type":"datetime"}]},{"data_columns":[{"name":"1533268800000","name_formatted":"03/08/18 06:00:00","code":"1533268800000","type":"datetime"}]},{"data_columns":[{"name":"1533272400000","name_formatted":"03/08/18 07:00:00","code":"1533272400000","type":"datetime"}]},{"data_columns":[{"name":"1533276000000","name_formatted":"03/08/18 08:00:00","code":"1533276000000","type":"datetime"}]},{"data_columns":[{"name":"1533279600000","name_formatted":"03/08/18 09:00:00","code":"1533279600000","type":"datetime"}]},{"data_columns":[{"name":"1533283200000","name_formatted":"03/08/18 10:00:00","code":"1533283200000","type":"datetime"}]},{"data_columns":[{"name":"1533286800000","name_formatted":"03/08/18 11:00:00","code":"1533286800000","type":"datetime"}]},{"data_columns":[{"name":"1533290400000","name_formatted":"03/08/18 12:00:00","code":"1533290400000","type":"datetime"}]},{"data_columns":[{"name":"1533294000000","name_formatted":"03/08/18 13:00:00","code":"1533294000000","type":"datetime"}]},{"data_columns":[{"name":"1533297600000","name_formatted":"03/08/18 14:00:00","code":"1533297600000","type":"datetime"}]},{"data_columns":[{"name":"1533301200000","name_formatted":"03/08/18 15:00:00","code":"1533301200000","type":"datetime"}]},{"data_columns":[{"name":"1533304800000","name_formatted":"03/08/18 16:00:00","code":"1533304800000","type":"datetime"}]},{"data_columns":[{"name":"1533308400000","name_formatted":"03/08/18 17:00:00","code":"1533308400000","type":"datetime"}]},{"data_columns":[{"name":"1533312000000","name_formatted":"03/08/18 18:00:00","code":"1533312000000","type":"datetime"}]},{"data_columns":[{"name":"1533315600000","name_formatted":"03/08/18 19:00:00","code":"1533315600000","type":"datetime"}]},{"data_columns":[{"name":"1533319200000","name_formatted":"03/08/18 20:00:00","code":"1533319200000","type":"datetime"}]},{"data_columns":[{"name":"1533322800000","name_formatted":"03/08/18 21:00:00","code":"1533322800000","type":"datetime"}]},{"data_columns":[{"name":"1533326400000","name_formatted":"03/08/18 22:00:00","code":"1533326400000","type":"datetime"}]},{"data_columns":[{"name":"1533330000000","name_formatted":"03/08/18 23:00:00","code":"1533330000000","type":"datetime"}]},{"data_columns":[{"name":"1533333600000","name_formatted":"04/08/18 00:00:00","code":"1533333600000","type":"datetime"}]},{"data_columns":[{"name":"1533337200000","name_formatted":"04/08/18 01:00:00","code":"1533337200000","type":"datetime"}]},{"data_columns":[{"name":"1533340800000","name_formatted":"04/08/18 02:00:00","code":"1533340800000","type":"datetime"}]},{"data_columns":[{"name":"1533344400000","name_formatted":"04/08/18 03:00:00","code":"1533344400000","type":"datetime"}]},{"data_columns":[{"name":"1533348000000","name_formatted":"04/08/18 04:00:00","code":"1533348000000","type":"datetime"}]},{"data_columns":[{"name":"1533351600000","name_formatted":"04/08/18 05:00:00","code":"1533351600000","type":"datetime"}]},{"data_columns":[{"name":"1533355200000","name_formatted":"04/08/18 06:00:00","code":"1533355200000","type":"datetime"}]},{"data_columns":[{"name":"1533358800000","name_formatted":"04/08/18 07:00:00","code":"1533358800000","type":"datetime"}]},{"data_columns":[{"name":"1533362400000","name_formatted":"04/08/18 08:00:00","code":"1533362400000","type":"datetime"}]},{"data_columns":[{"name":"1533366000000","name_formatted":"04/08/18 09:00:00","code":"1533366000000","type":"datetime"}]},{"data_columns":[{"name":"1533369600000","name_formatted":"04/08/18 10:00:00","code":"1533369600000","type":"datetime"}]},{"data_columns":[{"name":"1533373200000","name_formatted":"04/08/18 11:00:00","code":"1533373200000","type":"datetime"}]},{"data_columns":[{"name":"1533376800000","name_formatted":"04/08/18 12:00:00","code":"1533376800000","type":"datetime"}]},{"data_columns":[{"name":"1533380400000","name_formatted":"04/08/18 13:00:00","code":"1533380400000","type":"datetime"}]},{"data_columns":[{"name":"1533384000000","name_formatted":"04/08/18 14:00:00","code":"1533384000000","type":"datetime"}]},{"data_columns":[{"name":"1533387600000","name_formatted":"04/08/18 15:00:00","code":"1533387600000","type":"datetime"}]},{"data_columns":[{"name":"1533391200000","name_formatted":"04/08/18 16:00:00","code":"1533391200000","type":"datetime"}]},{"data_columns":[{"name":"1533394800000","name_formatted":"04/08/18 17:00:00","code":"1533394800000","type":"datetime"}]},{"data_columns":[{"name":"1533398400000","name_formatted":"04/08/18 18:00:00","code":"1533398400000","type":"datetime"}]},{"data_columns":[{"name":"1533402000000","name_formatted":"04/08/18 19:00:00","code":"1533402000000","type":"datetime"}]},{"data_columns":[{"name":"1533405600000","name_formatted":"04/08/18 20:00:00","code":"1533405600000","type":"datetime"}]},{"data_columns":[{"name":"1533409200000","name_formatted":"04/08/18 21:00:00","code":"1533409200000","type":"datetime"}]},{"data_columns":[{"name":"1533412800000","name_formatted":"04/08/18 22:00:00","code":"1533412800000","type":"datetime"}]},{"data_columns":[{"name":"1533416400000","name_formatted":"04/08/18 23:00:00","code":"1533416400000","type":"datetime"}]},{"data_columns":[{"name":"1533420000000","name_formatted":"05/08/18 00:00:00","code":"1533420000000","type":"datetime"}]},{"data_columns":[{"name":"1533423600000","name_formatted":"05/08/18 01:00:00","code":"1533423600000","type":"datetime"}]},{"data_columns":[{"name":"1533427200000","name_formatted":"05/08/18 02:00:00","code":"1533427200000","type":"datetime"}]},{"data_columns":[{"name":"1533430800000","name_formatted":"05/08/18 03:00:00","code":"1533430800000","type":"datetime"}]},{"data_columns":[{"name":"1533434400000","name_formatted":"05/08/18 04:00:00","code":"1533434400000","type":"datetime"}]},{"data_columns":[{"name":"1533438000000","name_formatted":"05/08/18 05:00:00","code":"1533438000000","type":"datetime"}]},{"data_columns":[{"name":"1533441600000","name_formatted":"05/08/18 06:00:00","code":"1533441600000","type":"datetime"}]},{"data_columns":[{"name":"1533445200000","name_formatted":"05/08/18 07:00:00","code":"1533445200000","type":"datetime"}]},{"data_columns":[{"name":"1533448800000","name_formatted":"05/08/18 08:00:00","code":"1533448800000","type":"datetime"}]},{"data_columns":[{"name":"1533452400000","name_formatted":"05/08/18 09:00:00","code":"1533452400000","type":"datetime"}]},{"data_columns":[{"name":"1533456000000","name_formatted":"05/08/18 10:00:00","code":"1533456000000","type":"datetime"}]},{"data_columns":[{"name":"1533459600000","name_formatted":"05/08/18 11:00:00","code":"1533459600000","type":"datetime"}]},{"data_columns":[{"name":"1533463200000","name_formatted":"05/08/18 12:00:00","code":"1533463200000","type":"datetime"}]},{"data_columns":[{"name":"1533466800000","name_formatted":"05/08/18 13:00:00","code":"1533466800000","type":"datetime"}]},{"data_columns":[{"name":"1533470400000","name_formatted":"05/08/18 14:00:00","code":"1533470400000","type":"datetime"}]},{"data_columns":[{"name":"1533474000000","name_formatted":"05/08/18 15:00:00","code":"1533474000000","type":"datetime"}]},{"data_columns":[{"name":"1533477600000","name_formatted":"05/08/18 16:00:00","code":"1533477600000","type":"datetime"}]},{"data_columns":[{"name":"1533481200000","name_formatted":"05/08/18 17:00:00","code":"1533481200000","type":"datetime"}]},{"data_columns":[{"name":"1533484800000","name_formatted":"05/08/18 18:00:00","code":"1533484800000","type":"datetime"}]},{"data_columns":[{"name":"1533488400000","name_formatted":"05/08/18 19:00:00","code":"1533488400000","type":"datetime"}]},{"data_columns":[{"name":"1533492000000","name_formatted":"05/08/18 20:00:00","code":"1533492000000","type":"datetime"}]},{"data_columns":[{"name":"1533495600000","name_formatted":"05/08/18 21:00:00","code":"1533495600000","type":"datetime"}]},{"data_columns":[{"name":"1533499200000","name_formatted":"05/08/18 22:00:00","code":"1533499200000","type":"datetime"}]},{"data_columns":[{"name":"1533502800000","name_formatted":"05/08/18 23:00:00","code":"1533502800000","type":"datetime"}]},{"data_columns":[{"name":"1533506400000","name_formatted":"06/08/18 00:00:00","code":"1533506400000","type":"datetime"}]},{"data_columns":[{"name":"1533510000000","name_formatted":"06/08/18 01:00:00","code":"1533510000000","type":"datetime"}]},{"data_columns":[{"name":"1533513600000","name_formatted":"06/08/18 02:00:00","code":"1533513600000","type":"datetime"}]},{"data_columns":[{"name":"1533517200000","name_formatted":"06/08/18 03:00:00","code":"1533517200000","type":"datetime"}]},{"data_columns":[{"name":"1533520800000","name_formatted":"06/08/18 04:00:00","code":"1533520800000","type":"datetime"}]},{"data_columns":[{"name":"1533524400000","name_formatted":"06/08/18 05:00:00","code":"1533524400000","type":"datetime"}]},{"data_columns":[{"name":"1533528000000","name_formatted":"06/08/18 06:00:00","code":"1533528000000","type":"datetime"}]},{"data_columns":[{"name":"1533531600000","name_formatted":"06/08/18 07:00:00","code":"1533531600000","type":"datetime"}]},{"data_columns":[{"name":"1533535200000","name_formatted":"06/08/18 08:00:00","code":"1533535200000","type":"datetime"}]},{"data_columns":[{"name":"1533538800000","name_formatted":"06/08/18 09:00:00","code":"1533538800000","type":"datetime"}]},{"data_columns":[{"name":"1533542400000","name_formatted":"06/08/18 10:00:00","code":"1533542400000","type":"datetime"}]},{"data_columns":[{"name":"1533546000000","name_formatted":"06/08/18 11:00:00","code":"1533546000000","type":"datetime"}]},{"data_columns":[{"name":"1533549600000","name_formatted":"06/08/18 12:00:00","code":"1533549600000","type":"datetime"}]},{"data_columns":[{"name":"1533553200000","name_formatted":"06/08/18 13:00:00","code":"1533553200000","type":"datetime"}]},{"data_columns":[{"name":"1533556800000","name_formatted":"06/08/18 14:00:00","code":"1533556800000","type":"datetime"}]},{"data_columns":[{"name":"1533560400000","name_formatted":"06/08/18 15:00:00","code":"1533560400000","type":"datetime"}]},{"data_columns":[{"name":"1533564000000","name_formatted":"06/08/18 16:00:00","code":"1533564000000","type":"datetime"}]},{"data_columns":[{"name":"1533567600000","name_formatted":"06/08/18 17:00:00","code":"1533567600000","type":"datetime"}]},{"data_columns":[{"name":"1533571200000","name_formatted":"06/08/18 18:00:00","code":"1533571200000","type":"datetime"}]},{"data_columns":[{"name":"1533574800000","name_formatted":"06/08/18 19:00:00","code":"1533574800000","type":"datetime"}]},{"data_columns":[{"name":"1533578400000","name_formatted":"06/08/18 20:00:00","code":"1533578400000","type":"datetime"}]},{"data_columns":[{"name":"1533582000000","name_formatted":"06/08/18 21:00:00","code":"1533582000000","type":"datetime"}]},{"data_columns":[{"name":"1533585600000","name_formatted":"06/08/18 22:00:00","code":"1533585600000","type":"datetime"}]},{"data_columns":[{"name":"1533589200000","name_formatted":"06/08/18 23:00:00","code":"1533589200000","type":"datetime"}]},{"data_columns":[{"name":"1533592800000","name_formatted":"07/08/18 00:00:00","code":"1533592800000","type":"datetime"}]},{"data_columns":[{"name":"1533596400000","name_formatted":"07/08/18 01:00:00","code":"1533596400000","type":"datetime"}]},{"data_columns":[{"name":"1533600000000","name_formatted":"07/08/18 02:00:00","code":"1533600000000","type":"datetime"}]},{"data_columns":[{"name":"1533603600000","name_formatted":"07/08/18 03:00:00","code":"1533603600000","type":"datetime"}]},{"data_columns":[{"name":"1533607200000","name_formatted":"07/08/18 04:00:00","code":"1533607200000","type":"datetime"}]},{"data_columns":[{"name":"1533610800000","name_formatted":"07/08/18 05:00:00","code":"1533610800000","type":"datetime"}]},{"data_columns":[{"name":"1533614400000","name_formatted":"07/08/18 06:00:00","code":"1533614400000","type":"datetime"}]},{"data_columns":[{"name":"1533618000000","name_formatted":"07/08/18 07:00:00","code":"1533618000000","type":"datetime"}]},{"data_columns":[{"name":"1533621600000","name_formatted":"07/08/18 08:00:00","code":"1533621600000","type":"datetime"}]},{"data_columns":[{"name":"1533625200000","name_formatted":"07/08/18 09:00:00","code":"1533625200000","type":"datetime"}]},{"data_columns":[{"name":"1533628800000","name_formatted":"07/08/18 10:00:00","code":"1533628800000","type":"datetime"}]},{"data_columns":[{"name":"1533632400000","name_formatted":"07/08/18 11:00:00","code":"1533632400000","type":"datetime"}]},{"data_columns":[{"name":"1533636000000","name_formatted":"07/08/18 12:00:00","code":"1533636000000","type":"datetime"}]},{"data_columns":[{"name":"1533639600000","name_formatted":"07/08/18 13:00:00","code":"1533639600000","type":"datetime"}]},{"data_columns":[{"name":"1533643200000","name_formatted":"07/08/18 14:00:00","code":"1533643200000","type":"datetime"}]},{"data_columns":[{"name":"1533646800000","name_formatted":"07/08/18 15:00:00","code":"1533646800000","type":"datetime"}]},{"data_columns":[{"name":"1533650400000","name_formatted":"07/08/18 16:00:00","code":"1533650400000","type":"datetime"}]},{"data_columns":[{"name":"1533654000000","name_formatted":"07/08/18 17:00:00","code":"1533654000000","type":"datetime"}]},{"data_columns":[{"name":"1533657600000","name_formatted":"07/08/18 18:00:00","code":"1533657600000","type":"datetime"}]},{"data_columns":[{"name":"1533661200000","name_formatted":"07/08/18 19:00:00","code":"1533661200000","type":"datetime"}]},{"data_columns":[{"name":"1533664800000","name_formatted":"07/08/18 20:00:00","code":"1533664800000","type":"datetime"}]},{"data_columns":[{"name":"1533668400000","name_formatted":"07/08/18 21:00:00","code":"1533668400000","type":"datetime"}]},{"data_columns":[{"name":"1533672000000","name_formatted":"07/08/18 22:00:00","code":"1533672000000","type":"datetime"}]},{"data_columns":[{"name":"1533675600000","name_formatted":"07/08/18 23:00:00","code":"1533675600000","type":"datetime"}]}],"column_type":"","row_type":"","total_results":"248","layers":[]}]

 

Hi All, I'm facing issue in parsing this JSON. The Output should look like as follows. I tried related posts for JSON parsing but couldn't do much to get the desired output. Any help would be much appreciated.

DateKKKK
01/08/18 00:00:003
01/08/18 01:00:00

0

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

As I always say when parsing JSON, start with the JSON parse tool, then parse the 'name' field into it's different sections. There are likely to be subsections in your data which means streams have to be treated in different ways, isolate those streams with the filter tool then use the cross-tab.

 

Example with your data attached.

 

Ben

Chaks
6 - Meteoroid

Thanks Ben, it was helpful. It helped me a lot to understand the JSON now, will keep this in mind.  

Labels