Skip to main content
  • EN

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

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.

 

 

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

30,102
Posts
114,262
Replies
37,736
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.