Skip to main content
Solved

FME SQLExecutor Returns only an Empty Column

  • 22 July 2024
  • 1 reply
  • 25 views

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?

1 reply

Userlevel 4
Badge +17

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