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.
ummm.. have you tried removing the word DISTINCT from your query?
Did that due the trick?
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...