Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Join

meitata
7 - Meteor

I tried to joining my file with 166.723 row

meitata_0-1653295776105.png

but the my output (Left union Join) have 166.761 (Left 142.001 and Join 24.760). How to fix it and get 166.723 row as output?

8 REPLIES 8
DataNath
17 - Castor

Are you able to expand? What are you joining on? Are they exactly the same?

 

All we can tell currently is that whatever you're joining on, there are 142,001 records where the field you have chosen can't find a match across the 2 inputs, and so you'll need to fix this.

MichaelThomsen94
6 - Meteoroid

Hey Meitata.
To get all rows as of both files as an output, it is necessary that the specific fields you are joining on are represented in all of the rows. So make sure to that you join on the correct field. Otherwise you can join by the Record position

messi007
15 - Aurora
15 - Aurora

@meitata,

 

Please check the key used on the Join.

Make sure your keys are unique in both side left and right.

 

Hope this helps!

Regards,

meitata
7 - Meteor

Both of them hv 1 column as config column, and I know that thing should not happen but that's happened and I kinda confused with that....

IraWatt
17 - Castor
17 - Castor

The reason you get more records from the (Left union Join) is because your join condition is not one to one. Your join must be many to one or many to many meaning the values your joining on are not unique.

MichaelThomsen94
6 - Meteoroid

Can you attach your file/Workflow?

DataNath
17 - Castor

@meitata are you able to share extra screenshots that show the fields etc? Or perhaps the workflow? Otherwise it's kind of impossible to diagnose the issue. The only way this will be happening is if there aren't matching values in the two fields you've selected as the join condition. 

Ladarthure
14 - Magnetar
14 - Magnetar

@meitata if you want to check that the field you use in your join is unique, you can do this with a summarize tool before your join on each files by doing a count and a count distinct on your join field, if you have more values in the count than in the count distinct, it means you have duplicate rows on this key. if it is the same, it is fine.

 

You could also do this after your join in the J output but first you can group by your join key and you will see the rows that have more than one occurence, by filtering the rows where the count is different of 1.

Labels