Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

tonyppham503
8 - Asteroid

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? 

1 REPLY 1
tonyppham503
8 - Asteroid

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

Labels
Top Solution Authors