community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Data mismatch

Highlighted
Asteroid

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

Niranjan

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?

 

Cheers,

Asteroid

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

Alteryx Certified Partner

@Niranjan123 

 

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.

 

Cheers,

Labels