Skip to main content
Solved

Creating new attributes based on another attribute's value


Forum|alt.badge.img

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.

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

3 replies

takashi
Influencer
  • Best Answer
  • October 18, 2019

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.


danilo_fme
Evangelist
Forum|alt.badge.img+44
  • Evangelist
  • October 18, 2019

Nice job @takashi


Forum|alt.badge.img

Thanks Takashi!


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