Skip to main content
Question

create / rename attribute based on string

bubblebeb
Contributor
Forum|alt.badge.img+6

I am trying to create multiple attributes based on the string in a single attribute. E.g. I have a series of features with percentages for each.

I want to create an attribute for each feature. There may be multiple features with the same name.

 

This is the example source

Week NoUser% 1Tim151Sam252Tim122Sam193Tim93Sam104Tim254Sam15Tim145Sam726Tim526Sam3

 

And this is what I want it to output

 

Week 1 %Week 2 %Week 3 %Week 4 %Week 5 %Week 6 %Tim15129251452Sam2519101723

 

I have tried BulkAttributeRenamer and cant get it to work.

This is how I tried it (one of many attempts).

 

any help on this would be great.

Thanks

Seb

2 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • March 25, 2020

If you use the down arrow, next to the String field, you can chose the Text Editor.

That allows you to put in the String field: Week @Value(Weekno).

Only change the % attribute.

Then use Aggregator (group by the user attribute) to merge the lines.

That should result in what you want.

Hope this helps.

ebygomm
Influencer
Forum|alt.badge.img+38
  • ebygommInfluencer
  • Influencer
  • March 25, 2020

I think there is an issue with the BulkAttributeRenamer in certain versions of FME which means it's not possible to add a suffix. I'll see if i can find the link.

It's not the best to use if you are trying to use an attribute to assign the suffix anyway

I'd use an attribute creator like this and then expose the attributes if necessary

It'll show a red cog but it will still work, if red cogs offend you can put the first statement in a separate attribute creator

Reply


Helpful Members This Week

Community Stats

31,340
Posts
118,850
Replies
38,930
Members

Latest FME

Terms & ConditionsCookie settings

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
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.