SOLVED
Need help in JSON transformation
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
Padma_
7 - Meteor
‎05-30-2024
07:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I need help in JSON transformation, showing the input and expected output here.
Input, have lakhs of rows like below
Header | JSON String |
AvailableGB | 500 |
TotalGB | 600 |
UsedGB | 100 |
AvailableGB | 1900 |
TotalGB | 2000 |
UsedGB | 100 |
Expected output
I tried cross tab, without group by, it outputs only 1 record, but I have lakhs of rows, when I do group by the the out put is in the same above format itself.
AvailableGB | TotalGB | UsedGB |
500 | 600 | 100 |
1900 | 2000 | 100 |
Solved! Go to Solution.
Labels:
- Labels:
- API
3 REPLIES 3
Raj
16 - Nebula
‎05-30-2024
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Padma_ please find the workflow attached
mark done if solved.
naveenu
6 - Meteoroid
‎05-31-2024
04:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Padma,
You just need to insert a multi-row tool to Group By Header so that each group header gets auto-numbered ([Row-1:New_Field]+1); And then use Cross-Tab tool to group by this New_Field.
Hope this helps.
jdminton
12 - Quasar
‎05-31-2024
04:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/3A331B3922338C3D350C8AB30CC1872B/responsive_peak/images/icon_anonymous_message.png)