SOLVED
Convert API output which is a single field to a table
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
gatortone
6 - Meteoroid
‎11-05-2018
03:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
Labels:
- Labels:
- API
- Download
- Output
- Regex
- Transformation
4 REPLIES 4
BenMoss
ACE Emeritus
‎11-05-2018
03:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
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
17 - Castor
‎11-05-2018
03:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-05-2018
05:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This worked like a charm! Thanks so much!
‎11-05-2018
08:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for this! This method worked. Thank you again!