Question

Transpose and Aggegate the JSON body data extracted

A
Rank
Badge +4

Hello Experts..

I need your Guidance and Help..

would like to transpose the information available in the FME template i have attached ..

In attribute Keeper Transformer - I have 2 fields name JSON index and Data ..

I want to JSON Index in Row as heading and Data is its corresponding Value..

 

I have attached workspace ..

Also , I have tried to follow this Article " https://community.safe.com/s/question/0D5Dm000006Zdi5KAC/transpose-a-table"

I want to transpose this and aggregate it

imageThe results Comes in this way

image.png 

Kindly Support and Guide

 

Thank You

2 replies

A
Rank
Badge +4

Hello Experts

Any Guidance to the query posted to transpose the attribute.

Your suggestions highly appreciated

Kindly guide

Thank you​

​

hkingsbury
Rank
Userlevel 5
Badge +29

You've basically got it in your last screenshot. Now you need to run it through an aggregator making sure you merge all attributes

image 

depending on how much data your pivoting (expecting more than one output row) you may need to set the groupby to an attribute that will group the inputs into their expected outputs

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd

Reply


Community Stats

28,681
Posts
109,409
Replies
36,542
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.