Skip to main content
Solved

How to update multiple attributes based on keywords?

  • September 12, 2016
  • 4 replies
  • 14 views
E

Hi all,

 

 

I would like to update attributes bases on certain keywords.

 

My reader consists of XML files, writing to an Access DB.

I'd like to do the following:

If in the column Official_name a certain keyword is detected I'd like to have the columns Category_main and Category_sub updated by various values.

E.g.

 

Official name is "B&B; FME City" - keyword B&B; is found and Category_main should be updated to Hotel/Motel, Category_sub is updated to "Bed & Breakfast & Guest Houses" Official_name Category_main Category_sub B&B; FME City Hotel/Motel Bed & Breakfast & Guest Houses

Many thanks,

 

 

Ed

Best answer by mark2atsafe

You could also use the AttributeManager by itself. For the attribute value click the dropdown list and choose Conditional Values. That opens a dialog where you can set test conditions, much as if the TestFilter were embedded directly inside the AttributeManager.

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

4 replies

david_r
Evangelist
  • david_rEvangelist
  • September 12, 2016

Lots of different ways to do this, but one easy solution would be the TestFilter with an AttributeCreator for each category, e.g.

Add items to the TestFilter as needed, directing them to different AttributeCreators.

J
Forum|alt.badge.img+7

Hi @edttom

This can be achieved with a TestFilter that looks for specific keywords (you can use regex if you liked) and an AttributeManager that will update the values of the attributes Category_main and Category_sub.

Good luck!

mark2atsafe
Safer
Forum|alt.badge.img+43
  • mark2atsafeSafer
  • Safer
  • Best Answer
  • September 12, 2016

You could also use the AttributeManager by itself. For the attribute value click the dropdown list and choose Conditional Values. That opens a dialog where you can set test conditions, much as if the TestFilter were embedded directly inside the AttributeManager.

E
  • edttom
  • Author
  • September 20, 2016

Thanks all! I ended up using the AttributeManager with the Conditional Values because I have multiple attributes I needed to update.

Reply


Helpful Members This Week

Community Stats

30,921
Posts
117,183
Replies
38,725
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.