Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Data mismatch


Hello All,


I got the Data mismatch when i am trying to connecting to the Oracle data source.

From Excel source with same mapping i got the right Count.

Could some one help me is there anything do I need to enable, need suggestions.


Thanks In Advance


Alteryx Certified Partner

Hi @Niranjan123 


We'll definitely need more details about what's going on.

Could you share some printscreens of configuration of both tools? How's your workflow?




please find the workflow im not getting actual count using this workflow

Alteryx Certified Partner



This picture is very inconclusive.

It's not possible to see what's coming in within your join tools, and it's impossible to compare your datasets (Excel and Oracle).


What I'd strongly recommend is that you double check for cartesian joins. 

To do that, use the Unique tool so you can see if there are duplicates on your key fields being used to join the datasets.