Question

Using LIKE or Wildcardoperator in Feature Merger

Forum|Forum|8 years ago
December 8, 2017
2 replies
253 views

+1

kanthsri74

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

takashi
Forum|Forum|8 years ago
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.

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?