Alteryx Designer Desktop Discussions

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

Need help with Teradata ODBC SQL Editor Coding!!

swpaeng00
5 - Atom

Context

Hello Alteryx Community! I am in desperate need of your expertise!

I am using Teradata ODBC in Alteryx to extract data from SAP but I noticed a huge problem I can't seem to 

work around: Alteryx only extracts Unique rows of data -- as in if there are any rows with the exact same sets of entries, 

Alteryx will completely disregard them!! (At the very least, I think)

And I need ALL the lines from the SAP to be run through Alteryx.

 

Currently, Alteryx is extracting approximately 102,000 rows of data from SAP while approximately 110,400 rows of data exist in the

specific account I need to access.

 

Request

Could anyone help me with the SQL Editor code to make it extract Every row of data that exist within that specific account?

 

Thank you so much Alteryx Community. I've attached the sample workflow below as well as screenshots of my current SQL Editor code, and the number of rows that Alteryx extracts vs. what actually exist.

3 REPLIES 3
apathetichell
18 - Pollux

ummm.. have you tried removing the word DISTINCT from your query?

apathetichell
18 - Pollux

Did that due the trick?

swpaeng00
5 - Atom

Yes, thank you so much!

 

But now I seem to be getting the opposite, but smaller problem. 
Alteryx is now pulling out approximately 120 More lines than what's in the SAP...

Labels