Skip to main content
Question

Using LIKE or Wildcardoperator in Feature Merger

  • December 8, 2017
  • 2 replies
  • 194 views
K
Forum|alt.badge.img+1

Hi,

I have to merge two tables with the common field.. one is from plain sql database and other is feature class..

Here I am using Feature Merger transformer..But I have to query the data in feature class using wild card search (data) from table1.

SQLDatabase-------------------(Select Code from Table1)

|

|

FeatureMerger ----> I want to query the data FCField like Code

|

|

FeatureClass -----------------(Select FCField from Featureclass)

Any help would be highly appreciated.

Cheers,

Srikanth Dasari

2 replies

takashi
Contributor
Forum|alt.badge.img+21
  • takashiContributor
  • Contributor
  • December 8, 2017
Unfortunately the FeatureMerger doesn't support LIKE operation.

 

If the feature class was a table in the same database, what SQL statement would perform ideal table joining? Possibly a solution might be found depending on the WHERE clause in the SQL statement.

 

 

K
Forum|alt.badge.img+1
  • kd
  • December 8, 2017

Hi @kanthsri74,

Have you checked the InlineQuerier? It is a powerful alternative for the FeatureMerger and it supports LIKE statements.

https://www.safe.com/transformers/inline-querier/

Reply


Helpful Members This Week

Community Stats

30,985
Posts
117,433
Replies
38,764
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.