Solved

Each column value in separate row

  • 24 March 2020
  • 3 replies
  • 0 views
F

I am new to FME and I wish to make the following transformation.

From:

IDColAColBColC1A1B1C12A2B2C23A3B3C34A4B4C45A5B5C5

 

To:

IDColumnNameValue1ColAA11ColBB11ColCC12ColAA22ColBB22ColCC23ColAA33ColBB33ColCC34ColAA44ColBB44ColCC45ColAA55ColBB55ColCC5

 

Can anyone help me out?

icon

Best answer by ebygomm 24 March 2020, 17:38

View original

3 replies

ebygomm
Rank
Userlevel 1
Badge +10

AttributeExploder, keep Attributes set to Yes, followed by a tester to get rid of the format attributes and an attribute keeper to keep only the ID, attribute name and attribute value

 

F

AttributeExploder, keep Attributes set to Yes, followed by a tester to get rid of the format attributes and an attribute keeper to keep only the ID, attribute name and attribute value

 

Thanks a lot!

For a more generic approach for handling different CSV files, I've altered the Tester to:

ebygomm
Rank
Userlevel 1
Badge +10

Thanks a lot!

For a more generic approach for handling different CSV files, I've altered the Tester to:

Yes, it's a pity that you cannot choose to ignore unexposed/format attributes when exploding

You can vote for it here

https://knowledge.safe.com/idea/19187/option-to-select-attributes-that-should-not-be-exp.html

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
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.