SOLVED
Parse JSON column in table and output original columns with JSON data columns
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
DougHawes
5 - Atom
‎06-13-2017
06:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a table with multiple columns that includes one column with JSON data. I would like my final output to include all the non-JSON columns along with the parsed columns from the JSON data.
Example Data:
User | Date | AuditData |
Bob | 1/1/2017 | { "Report": "Gross Sales", "IP": "111.111.111"} |
Julie | 1/2/2017 | { "Report": "COGS", "IP": "222.222.222"} |
Elle | 1/2/2017 | { "Report": "Gross Sales", "IP": "333.333.333"} |
Desired Output:
User | Date | Report | IP |
Bob | 1/1/2017 | Gross Sales | 111.111.111 |
Julie | 1/2/2017 | COGS | 222.222.222 |
Elle | 1/2/2017 | Gross Sales | 333.333.333 |
Solved! Go to Solution.
Labels:
- Labels:
- Output
- Parse
- Transformation
3 REPLIES 3
jdunkerley79
ACE Emeritus
‎06-13-2017
07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-13-2017
10:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you jdunkerley79, I tried the Cross Tab earlier, but did not have First Row checked.
rrikkala
5 - Atom
‎10-12-2022
02:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is there a way we can do this for multiple JSON type columns at once ?