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')
