Solved

Creating new attributes based on another attribute's value

Forum|Forum|6 years ago
October 18, 2019
3 replies
75 views

robbie_botha
70 replies

Hi there,

I've seen some similar questions already asked about this, but none of them were quite the same as what I'm trying to do. That or I simply misunderstood.

Essentially, my data looks like this:

WeekCountLength150350027040003653800

And what I need to get to is something like this:

Week_1Week_2Week_3(Count)507065(Length)350040003800

Now if it where only these 3 cases above, I could quite easily take a more manual, individual approach, but in my actual data there are a lot of "weeks" so I need to have it pretty dynamic.

Any suggestions?

Best regards,

Best answer by takashi

Hi @robbie_botha, this workspace example illustrates a possible way.

Assuming that the destination data format is Excel. The NumToAlpha converter is a custom transformer from FME Hub.

csv2xlsxw-with-transposing.fmwt (FME 2019.1.3)

Hope this helps.

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.