Question

Using LIKE or Wildcardoperator in Feature Merger

  • 8 December 2017
  • 2 replies
  • 38 views
K
Badge +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
Rank
Userlevel 2
Badge +17
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
Badge +1

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


Community Stats

28,707
Posts
109,479
Replies
36,553
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.