Connect to PROD ODBC 32 Bit & Run SQL Query

JJH — Mon, 25 May 2020 15:06:42 GMT

I am currently connecting to 32 bit ODBC database using the Input tool.

In this database connection, I am trying re-use an existing SQL query that:

1. joins 2 tables using a primary key

2. Renames

Wondering why I can't simply re-use existing SQL queries in the Alteryx input tool?

I am trying to avoid rewriting existing SQL queries just for Alteryx use.

Sample SQL Query

SELECT 
L1.NCUST Acct, 
L1.ANAME name, 

(SELECT SUBSTRING(T1.TCOKU, 1, 20) FROM TCOTXS T1 WHERE T1.TFEL1 = 'CKUAR' 
and T1.CLANG = 'e' and T1.TCODW = L1.CKUAR) type,


FROM LESFB L1 
WHERE L1.NCUST >100000
AND L1.ckuar IN ('a','b','c','d','h')

Re: Connect to PROD ODBC 32 Bit & Run SQL Query

JJH — Mon, 25 May 2020 22:34:49 GMT

Found a solution.

Ended up re-structuring the query to join the 2nd table after selecting 1st table.

topic Connect to PROD ODBC 32 Bit & Run SQL Query in Alteryx Server Discussions

Connect to PROD ODBC 32 Bit & Run SQL Query

Re: Connect to PROD ODBC 32 Bit & Run SQL Query