community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
SOLVED

Convert API output which is a single field to a table

Hi everyone,

 

I have a dataset that outputs from an API that looks just like this:

 

[{"Field1": true, "Field2": "blah blah blah", "Field3":12345}, {"Field1": false, "Field2": "blah blah blah", "Field3":67890}, etc]

 

How can I convert it to eventually look like:

 

Field1Field2Field3
trueblah blah blah12345
falseblah blah blah67890

 

Thank you for any assistance!

Alteryx Certified Partner
Alteryx Certified Partner
Step 1. Json parse (simple config just select your field).

Step 2. Text to columns on the json name field, usually with the . Delimiter to give you a record ID and appropriate column name for the value.

Step 3. Cross tab. Grouping by your ID field and setting the header field to be the 2nd part of the split and value field to be the json value string.

Ben
Alteryx Certified Partner
Alteryx Certified Partner

Hi @gatortone

 

Here's the solution I thought.

 

WorkflowJSON.PNG

This worked like a charm!  Thanks so much!

Thank you for this!  This method worked.  Thank you again!

Labels