Skip to main content
  • EN

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

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.

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!

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.

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

Reply


Community Stats

30,353
Posts
115,357
Replies
38,089
Members
Terms & ConditionsCookie 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.