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

icon

Best answer by danilo_fme 20 September 2021, 03:12

View original

3 replies

danilo_fme
Rank
Userlevel 4
Badge +30

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
Rank
Userlevel 4
Badge +30

that is brilliant. thank you

Thanks!

Reply


Community Stats

28,731
Posts
109,530
Replies
36,566
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.