I am using SQL Executer but in the output port I am not getting the attribute exposed automatically. My SQL expression I am only counting the inputs so I cannot expose the attribute using “Populate Attribute from SQL”. I cannot use Attribute exposer every time I am using the SQL. Is there any other way to do this.
Solved
Attribute Exposure in SQL Executer
Best answer by david_r
Depending on the database it might be a good idea to set a column alias when using functions, e.g.
select count(*) as "MY_COUNT"
from my_schema.my_table
where my_criteria
In this case you should expose MY_COUNT in the SQLExecutor.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.