Error in running SQL query in Dynamic input tool with / symbol changes to _

Question

Hi I am trying to run SQL query which is in an excel file  using Dynamic input tool and using a field (ACTION: Change file / table name) to read the query. The SQL code has a / sign I notice that when I pass this field with query the SQL code with / is replace by _ and am gettting an error. can you  please help

Lumjing · Answer

@rzdodson thank you for the reply. Yes, I am able to successfully run the query in SQL editor. In Alteryx i am getting "No Columns Returned" error. There is 2 places in the SQL query where a "sum([Field] / 1000" when I pass this in "Dynamic Input" tool using the Field (ACTION: Change file / table name) option. I get an error which I check the error the only thing that gets changed in the query is "sum([Field] _1000" and when I run this error in SQL editor I get "Incorrect Syntax error" in this line. Sorry I am not able to share the screen shots. Thanks for the help.

I tried below things but could not fix the issue

1) I have changed the data type of the "SQL Query" field in alteryx to "V_W_String" which was by default "V_String"

2) I created a new column "SQL Query replaced" and read the "SQL Query" column

3) Used "sum([Field] "/" 1000"

rzdodson · Answer

@Lumjing what is the error that you are getting? Can you screenshot it? Also, what does your SQL query look like that you are attempting to pass in? Have you confirmed that it does not contain errors (re: you have successfully ran the query in another system)?