+3Using 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?
Best answer by ctredinnick
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.
+19The 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.
