Skip to main content
Solved

FeatureReader couldn't read the features with Where statement -TAB file

T

Hi experts,

I want to read the TAB file but with WHERE statement to filter the number of records that I want. It could not perform and run into errors like below. Could you help to indicate where I did wrong. THanks.

 

I had tried without "" for the fields name, treating the values like string and not string.

Performing query against MAPINFO_EXTENDED dataset `C:\\QV\\MapData\\PARCEL.tab'

UniversalReader: Unable to emulate search type 'fme_all_features' because fme_where is requested

FeatureReader_2 (QueryFactory): A fatal error has occurred. Check the logfile above for details

A fatal error has occurred. Check the logfile above for detailsCapture

Best answer by danilo_fme

Hi @tranhaiphuong88 

 

I re-created your case in my FME Workbench Desktop using the transformer InlineQuerier.

This transformer creates a temporary SQLite database, and creates a table for each input object that is connected to it. In the parameters dialog, you may create any number of SQL queries that use these tables.

 

Workspace01The configuration into transformer:

select * from Parks where TreeCount=10

Workspace02Attached the Workspace.

 

Thanks in Advance,

Danilo

 

 

View original
Did this help you find an answer to your question?

3 replies

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • Best Answer
  • September 20, 2021

Hi @tranhaiphuong88 

 

I re-created your case in my FME Workbench Desktop using the transformer InlineQuerier.

This transformer creates a temporary SQLite database, and creates a table for each input object that is connected to it. In the parameters dialog, you may create any number of SQL queries that use these tables.

 

Workspace01The configuration into transformer:

select * from Parks where TreeCount=10

Workspace02Attached the Workspace.

 

Thanks in Advance,

Danilo

 

 

T

that is brilliant. thank you

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • danilo_fmeEvangelist
  • Evangelist
  • September 26, 2021
tranhaiphuong88 wrote:

that is brilliant. thank you

Thanks!

Reply


Helpful Members This Week

Community Stats

31,182
Posts
118,182
Replies
38,791
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.