SOLVED
Transpose Fields and Values
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
hellyars
13 - Pulsar
‎03-01-2021
01:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a json input from a web scrape. I need to transpose the data into a traditional table format. The Field Names are in JSON_NAME. The Values are in JSON_ValueString. Records (rows) start with each reference to "Aircraft".
From this...
To this...
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
2 REPLIES 2
apathetichell
19 - Altair
‎03-01-2021
01:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This would fit your description - but it seems like every two row may relate to one aircraft. You'd need to modify if if that's the case.
‎03-01-2021
01:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@apathetichell This works and you are correct, each aircraft has two lines associated with it. That's easy to clean up.
Thanks!
