Skip to main content
Solved

Make a short wide table into long thin

  • December 12, 2016
  • 3 replies
  • 91 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.

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

3 replies

todd_davis
Influencer
Forum|alt.badge.img+22
  • 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+22
  • Influencer
  • December 12, 2016
todd_davis wrote:

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
todd_davis wrote:

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.

 

 


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