Skip to main content
Solved

How to pivot or change the layout of a data table?


trevorb
Contributor
Forum|alt.badge.img+3

I am trying to go from this:

initial_weather_table 

to this:

weather_tableWhere "Current Weather" is the first "validTime" record and "Next 24 hrs" is the second "validTime" record.

 

I messed around with the concept in excel and came up with the following which might work but can't seem to replicate it in FME:

pivot_excel 

I've played with the AttributePivoter, StatisticsCalculator, AttributeExploder, and others and just can't seem to alter the table to something similar to what is shown above. The idea would be to go from reading in arcgis server service features and write out to an html table (or maybe something else) which would look like (or similar to) the above table.

 

Any ideas are greatly appreciated!

 

Best answer by virtualcitymatt

So the AttributeExploder is definitely needed here. Here's an example workflow

 

imageThe aggregator can then be used to get the data inline

View original
Did this help you find an answer to your question?

virtualcitymatt
Celebrity
Forum|alt.badge.img+35

So the AttributeExploder is definitely needed here. Here's an example workflow

 

imageThe aggregator can then be used to get the data inline


virtualcitymatt
Celebrity
Forum|alt.badge.img+35
virtualcitymatt wrote:

So the AttributeExploder is definitely needed here. Here's an example workflow

 

imageThe aggregator can then be used to get the data inline

Here's what the output looks like

image


trevorb
Contributor
Forum|alt.badge.img+3
  • Contributor
  • October 21, 2021

Your workflow worked for my needs. Thanks so much!


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