Skip to main content
  • EN

Using FME 2021, and 2023 SQLExecutor, I am running a simple query to return data from a non spatial table in SQL Server, but I am getting an empty column in return

 

The number of rows are exactly 145 and SQLExecutor result is showing that but the visual Preview just showing an empty column (again with correct 145 rows)

 

I even added a AttributeManager to script but same result is happening

 

Can you please let me know what I am doing wrong here?

The attributes have been read - you can see them on each feature if you click here:

But the attributes still need to be exposed. This tells the workspace what attributes you have, for other transformers to use. In the SQLCreator, add them in under Attributes to Expose, you can type them in, or it gives you an option to populate that list from the SQL query.

 

Community Stats

31,938
Posts
121,300
Replies
39,555
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.