Question

Columns to Rows in FME2019

Forum|Forum|5 years ago
December 4, 2019
2 replies
92 views

S

sam2130
2 replies

I know this has been asked many times, but i cannot get it to work.

My data is:

ObjectCategoryNumApple8091Apple

81122Apple8100Banana80913Banana81014Banana81155

And i want to turn it into

Object809810811Apple1022Banana131455

I've tried to do the method i've read on the forums using attributecreator, however, its not creating multiple columns based on the column names.

ie, in AttributeCreator:

NewAttribute: @Value(Category)

AttributeValue: @Value(Num)

doesnt do anything.

I am using FME 2019.

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.