Ask Your Question
2

How to output an array of JSON objects

asked 2018-01-10 05:45:56 -0500

Shruthi gravatar image

updated 2018-02-08 07:25:38 -0500

How can i convert my output into following format

For ex:- My query displays as follows when i preview it

 Record1: 
            a1: xxx
            b1: xxx
            c1: "xxx"
            ...........
            n1: xxx

I want convert this into the following format

[
    {
       ‘a1’: 10,
       ‘b1‘: 20,
       ‘c1’:  ‘xyz’,
        ...........,
        'n1': 80
   }
]
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-01-10 17:21:31 -0500

metadaddy gravatar image

Output formatting is done in the destination stage(s) of your pipeline. For example, if you are writing data to the local filesystem, select the JSON data format and set the JSON Content property to JSON Array of Objects.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-10 05:45:56 -0500

Seen: 193 times

Last updated: Feb 08