SQL: The query resulted in multiple columns named "xxx". Please resolve your query...

[tonyppham503]

I'm getting the following message from running a query in using the In-DB tools for MSSQL:

Error: Connect In-DB (2): The query resulted in multiple columns named "_NUM". Please resolve your query to return uniquely named columns.

My query returns multiple columns with the name "_NUM" and that is intentional for other downstream processes. What are my options to get this to work in Alteryx? 

[tonyppham503 · Accepted solution]

Oops mean to put this in Data Prep and Blending forum. Can we close this thread?