Can you get to 2023? If you can, then I have an answer. You really need 2023 as it contains a bug fix which allowed me to add some functionality to the AttributeValueSearcher that caters for this scenario.

Actually, as you are only searching one field, then you can do it with ease...without the above. Use the same method through to the featurejoiner and following the featurejoiner use a Tester, and test the "cable network contains id" (of course that is pretty wild in it selection with an id of 1 being found in any cable network value that contains 1, so you may need to add in some extra logic). That will return all the values in the cable network that match

There is a custom transformer located in FME Hub called FuzzyStringCompareFrom2Datasets. I'm not positive it will give the expected result in this scenario, but it may be worth a shot. https://hub.safe.com/publishers/cdalessandro/transformers/fuzzystringcomparefrom2datasets

Hi @gogopotter90​ ,

Looks like a cable network can be split by hyphen into two or more parts and the first part is always id. If my observation is correct, you can just split it with AttributeSplitter and then use ListIndexer (List Index to Copy: 0) to extrat the first part i.e. id.

It is not always the first part .

i am not sure which part does it .

It takes too long time to get output ,i have tried it

I have only Fme 2021 .

But it is not clear what should I do ,after feature joined but it looks too much data to join between left and right .

but anyway what should I do after tester .

do you have other method could I apply without taking too much time

If the value of 'id' can be in any part of 'cable network', do something like this (based on the workflow presented by todd_davis):