Skip to main content
Question

Transpose and Aggegate the JSON body data extracted


abnan0001
Supporter
Forum|alt.badge.img+7

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

abnan0001
Supporter
Forum|alt.badge.img+7
  • Author
  • Supporter
  • April 10, 2023

Hello Experts

Any Guidance to the query posted to transpose the attribute.

Your suggestions highly appreciated

Kindly guide

Thank you​


hkingsbury
Celebrity
Forum|alt.badge.img+49
  • Celebrity
  • April 10, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings