How to convert SQL json_build_object to Alteryx output?

vujennyfer

Hello, 

I am new to Alteryx and I am trying to create a JSON output with this information: 

jsonb_build_object(

'name', name,

'zip', zip,

'city', city,

'id', id,

'email', email,

'mobile', mobile,

) as data 

Output as the below: 

{"name": "Bob", "zip": "60021", "city": "Seattle", "id": "334455", "email": "abc-at-gmail.com", "mobile": null}

Any suggestions are appreciated! 

TrevorS

Hello @vujennyfer 
Thank you for your contribution to the Community!

To help make it easier for others to assist, it would be helpful to get some additional information on your [process, question or connection]. Here's what we recommend you include in your reply:

* What Alteryx Version are you using?
* Do you have a Workflow with sample data you can share?
* What about a Screenshot?

Posting for Fastest Possible Solution  
Thank you very much!