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.

 

Reply


Community Stats

30,102
Posts
114,260
Replies
37,733
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.