Skip to main content
  • EN

Hi,

Pretty new to FME, so hopefully I have all the terminology right and I’m asking the right sort of questions.

 

I have a feature set from Freshservice API of the available products in their asset system.
It’s mostly the Latitude and OptiPlex products I need to work with so the solution can work just for them.

I need to match the freshservice_product_name to a feature set that I don’t control and isn’t consistent.

As you can see the tesma-description is a bit of a mess but it’s all I have to try match up the freshservice_product_name to.


Can someone point me in the right track of how they would tackle this?

Thanks,

 

Hi ​@cg-wcc ,

Do you need to extract only rows whose "freshservice_product_name" value begins with (or contains) "Latitude" or "OptiPlex"?

If so, you can use Tester or TestFilter simply with operator "Begins With" or "Contains".

The criteria was more complex, “Contains Regex” operator or StringSearcher transcormer could also be helpful.

Tester Setting Example (Contains Operator)

 

Maybe the FuzzyStringComparer from FME Hub can be of help here.

Maybe you can add an extra attribute in FME to the table containing tesma description, something like

  • Remove the word Dell
  • Remove the word Macro
  • Maybe some more actions
  • After that, keep only the first 2 words

Hopefully now only the two words remain that are present in freshservice_product_name.

Thanks everyone, I’m going to use a combination of all your suggestions.

 

I found I can bring in another data source matched on serial number with the model details formatted perfectly, but I’m still going to match them off with a search against the tesma-description as I’ve found some of the descriptions are for the incorrect family and model.

Reply


Community Stats

31,821
Posts
120,861
Replies
39,452
Members

Latest FME

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.