In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

converting Table to JSON response

itskris5
5 - Atom

Hello Alteryx Community,

 

I am trying to convert a table data to JSON.

 

example table has the following values.

 

ID: 1
First_Name: Jane
City: London

Country: UK
Participant: 123

I am looking to have the above values converted to the following format. 

{
"values" : {
"ID" : "1" ,
"First_Name" : "Jane" ,
"City" : "London" ,
"Country" : "UK" ,
"Participant" : "123" 
}}

Appreciate the help. Thank you.
1 REPLY 1
echuong1
Alteryx Alumni (Retired)

You'll have to make some modifications, but the JSON Build tool is a good starting place.

 

echuong1_0-1617153687187.png

 

Labels
Top Solution Authors