Alteryx Designer Desktop Discussions

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

JOIN tool

adriana_1
Átomo

Hello all, 

I am using Join function on protected data, so I cannot post them here. But left result and join result showing me correct data. But Right join also shows me data that should be in JOIN result. What this can mean? Why the JOIN tool does not work properly? 

 

 

 

5 RESPUESTAS 5
Deano478
Cuásar

@adriana_1 without testing it on dummy data and understanding how your join tool is configured it's very hard to diagnose a problem. If you could post some dummy data similar to your data we can do a similar test

Manoj_k
Cometa

hi @adriana_1 , The Right Join might be showing unexpected data due to:

  • Incorrect Join type: Use "Left Join" to include all left records and only matching right records.
  • Join condition problem: Verify your joining rule matches records correctly.
  • Data duplication: Check for duplicates in either input causing extra joins.
  • Data type mismatch: Ensure joining fields have compatible data types.
  • Tool configuration error: Review Join tool settings for any unexpected options.
Rhys_Cooper
Cometa

@adriana_1Thank you for your question. @Manoj_k lists some excellent configurations to check, but to clarify on his first point, there is no option in the join tool to specifiy the type of join. Effectivley all types of joins ( left, right etc) are implicitly all included and reflected in the L,J,R Anchors. Two additional things to check is you have connected the incoming data streams to the correct input anchors too, and that you havent accidently selected 'join by record position' potentially. Also note that multiple join conditions (ie fields to join) on can be used, this can help get the missing records into the join.

 

Many thanks - Rhys Cooper

adriana_1
Átomo

Hello @Deano478 I tried to create dummy data and I did not have this problem. So there is an issue with data. Do you have any idea what can be the issue? 

peterr_h
Asteroide

If it doesn't replicate with the data, it'll be a DQ issue.

If you're joining on strings, are all of these identical? (caps, spaces, punctuation, etc.).

Do any of the cells have leading/trailing whitespace?

If you're joining on non-integer numeric fields, rounding could be an issue - sometimes the full value isn't displayed in the cell in the results window, so they could appear identical, but actually are not.

Etiquetas
Autores con mayor cantidad de soluciones