Skip to main content
Solved

Make a short wide table into long thin

  • December 12, 2016
  • 3 replies
  • 115 views

Hi,

I am trying to convert a table with 5k rows and 115 columns of data into a long table. I have 5 columns to fix and then about 100 which I want to take the column name and put that into another column and then have the values of that column in a field called Regs.

I've attached a sample excel file with what I'm wanting to do.

Thanks

Mark

Best answer by todd_davis

attributeexploder is the main transformer you want, as it will crate the column name as an attribute and the vale as another attribute and separate each into a value into a seperate feature.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

todd_davis
Influencer
Forum|alt.badge.img+23
  • Influencer
  • Best Answer
  • December 12, 2016

attributeexploder is the main transformer you want, as it will crate the column name as an attribute and the vale as another attribute and separate each into a value into a seperate feature.


todd_davis
Influencer
Forum|alt.badge.img+23
  • Influencer
  • December 12, 2016

attributeexploder is the main transformer you want, as it will crate the column name as an attribute and the vale as another attribute and separate each into a value into a seperate feature.

Here is an example skinny.fmw

 

 


  • Author
  • December 13, 2016

attributeexploder is the main transformer you want, as it will crate the column name as an attribute and the vale as another attribute and separate each into a value into a seperate feature.

That's great. Thanks. It works perfectly.