Skip to main content
  • EN

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

Hello Experts

Any Guidance to the query posted to transpose the attribute.

Your suggestions highly appreciated

Kindly guide

Thank you​

​

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


Community Stats

30,123
Posts
114,333
Replies
37,751
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.