Hi Folks,
I am trying to extract data using custom SQL Query. I am trying to inner join two tables. While the query itself is not throwing any error, the number of records I am fetching using SQL Query is way greater than when I am trying to do the same operation using Alteryx Join tool. I am taking the output from the Inner join in the Join Tool.
Can anyone help me in understanding why this query is not giving the expected result. The output should have only 45 records but using query in SQL Editor I am getting some 145 Records.
select T.ItemType,
B.Item,
from T
inner join B on T.PROJEKT_Counter = B.Zaehler
Hi @Anshita
1. Does any of these columns have null value?
2. Are you using join tool or in-db join tool?
3. Can share a snapshot of your join tool configuration?
Hi @atcodedog05 ,
1. There are definitely NULL values present. Any Idea on how to eliminate them. I tried with a NOT NULL Query but it seems not to be working. It is giving me an error.
3. Not able to share the screenshot due to security reasons. I am joining on a single field from the left and right inputs and taking the output directly from the J output anchor without using union.
Thanks in advance!
Hi @atcodedog05,
Thanks but really trying to combine all operations in a single query from the input tool directly! for now NOT NULL seems to be not working for me.
Hi @Anshita
Not null should work can you show me the query. There is a possibility that it can also be a blank and not null.