Skip to main content
  • EN

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

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

 

 

that is brilliant. thank you

that is brilliant. thank you

Thanks!

Reply


Community Stats

30,176
Posts
114,543
Replies
37,835
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.