Skip to main content
Solved

Reclassification of attributes into groups

arnold_bijlsma
Enthusiast
Forum|alt.badge.img+14
I have an address table where each address point is classified into 1 of about 500 classification codes. I need to reclassify / condense this into just 10 codes:

 

1 = Code R% = Residential

 

2 = Code C% = Commercial

 

3 = Code CE% = Educational

 

4 = Code CX% = Emergency Services

 

...etc.,

 

where % is a wildcard character

 

 

I have tried a couple of transformers, but most don't support wildcards, so the 'best' option so far I have come up with is 10 pairs of Tester+AttributeCreator transformers in sequence.

 

My feeling is that there may be an easier way. Is there?

 

 

(Note: I am aware of the overlap in codes. The second line classes all lines starting with C as Commercial, but then the third line reclassifies those starting with CE as Educational)

Best answer by fmelizard

Hi,

 

Yes there is, one AttributeCreator in which you make use of the conditional values definition.

 

http://blog.safe.com/2013/03/fmeevangelist113/
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

3 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • Best Answer
  • August 19, 2015
Hi,

 

Yes there is, one AttributeCreator in which you make use of the conditional values definition.

 

http://blog.safe.com/2013/03/fmeevangelist113/
arnold_bijlsma
Enthusiast
Forum|alt.badge.img+14
Hi Itay

 

 

Dankjewel. That was exactly what I was looking for! See below for some screenshots. And also thanks to Mark Ireland for the very well and clear written blog post.

 

 

My AttributeCreator Condition Definition:

 

 

 

My workspace, showing Before in pink and After in green:

 

fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • August 20, 2015
Graag gedaan, Its a great addition that I use very frequently wouldnt know what to do wothout it nowdays.

Helpful Members This Week

Community Stats

30,942
Posts
117,252
Replies
38,742
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.