SQL Query does not provide results

[711merchsupe]

Hi,

I have successfully created a query with no errors (tested query within Alteryx), however it doesn't return any data within the results box.  I am using SQL Server and ODBC database, when I refresh the results there is data within the input data box.

I tried to add a select tool, but since there doesn't appear to be any results there's no columns for me to pull/select.

I am using Alteryx Design X64.

[cjaneczko]

What happens if you put a browse tool after the query? Did you press Run at the top right? You can refresh and see the query on the left but not show results until you run the workflow.

[711merchsupe]

I used the browse tool and hit run, no results either way.  I am thinking its just this workflow.

I created a new workflow and used the same input and query, and I actually have results now.