Forum Discussion
@swatifunde - Thanks for following up. Take a look at this updated pipeline.
Community 13477 - Restructure JSON_2022_09_30.slp (11.6 KB)
The main logic to this is the Group By Fields snap that combines the data into a single array around your project id. The first Mapper snap moves the project id out of the $group_by element into the root where you want it. Then the second Mapper snap uses the new $p6ActivityList array as the root where we want make changes and we simply remove the project id from each level. If this syntax seems odd, review the documentation on the Mapper snap, particularly around the Pass Through option.
Great, its working as expected. Just small query , is it possible to remove first square bracket from final output?