Skip to main content
  • EN

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

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.

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

 

 

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.

 

 

Reply


Community Stats

30,126
Posts
114,365
Replies
37,763
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.