Convert API output which is a single field to a table

[gatortone]

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:

Field1	Field2	Field3
true	blah blah blah	12345
false	blah blah blah	67890

Thank you for any assistance!

[BenMoss · Accepted solution]

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

[Thableaus · Accepted solution]

Hi @gatortone

Here's the solution I thought.

[gatortone]

This worked like a charm!  Thanks so much!

[gatortone]

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