community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

Just "Select" without "From" in Input Data.

Hello Alteryx-Community,

my issue sounds quite simple, but is a challange for me.  How do I get the version of a mysql- and mssql-connection? I presume a query without a "From"-Clause in a Input Data-Tool is not allowed. Thus I get an error message for a sql-statement, which works in the Mysql Workbench. Do you have a solution for me? I need the version-number for a data-output, so a pre- or post-sql-statement might be not the right solution. 

 

 justselectwithoutfromstatement.jpg

Alteryx Certified Partner
Alteryx Certified Partner

Select @@version From TABLENAME

 

seems to work. Set the recordlimit to 1 otherwise you will get the version for every line in that table.

 

Ben

Highlighted

Thank you. This is it. 

Labels