Skip to main content
Solved

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

  • July 6, 2021
  • 3 replies
  • 35 views
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

 

 

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.

3 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • 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

 

 

Partner Solutial Brazil - www.solutial.com.br
T

that is brilliant. thank you

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • September 26, 2021

that is brilliant. thank you

Thanks!

Partner Solutial Brazil - www.solutial.com.br

Community Stats

32,070
Posts
121,771
Replies
39,696
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.