Join two data sets with 2 common fields

[samxhander09]

Hi, im trying to join two data sets with 2 common fields, but it returns some of the values as NULL, which should not happen.

Im joining by ID and Customer Account, all formats/data types are the same. What could I be doing wrong?

[samxhander09 · Accepted solution]

Hi, please ignore, i figured out the two data sets have diffrent row values. Thank you

[apathetichell]

Are you using a Join or join multiple? If you are using a Join and you Join on two fields. And neither field has nulls going in - the J anchor will have no nulls going out.

If that is not the case you probably have nulls in at least your J or R side going into the join.