Unable to join multiple data sources

[santosh4195]

I am getting N dimensional join error. Please help me with this.

[Thableaus]

Hey @santosh4195 

We would need to see some sample data at least to tell you what's going on with this join.

There's no mystery on how Alteryx does joins. The same logic that works for SQL and other tools is applied in Alteryx. So if you have multiple occurrences of your join keys on each side (left and right), you will see rows being multiplicated.

I recommend that you do a Data Profiling analysis to understand if that's the case.

Some useful tools you can use for that analysis:

Browse Tool

Basic Data Profile Tool

Field Summary Tool

Cheers,

[Qiu]

@santosh4195 
It is throwing warning, so maybe it has something to do with option below. Try to change it to some other options.