My input join field and output join field are text type, and my problem is that when I use "Add Join" all joins ok, but if I want to use "Join field" there are some records with Null, it seems like it doesn't recognize that the text are the same in fields from both tables.

  • 1
    If the join works just for some records it is likely that you have slight differences in the records not joining. Take one of the cases where it is not working and copy and paste the text of both sources in a text editor. You may have cases of spaces, punctuation, misspellings, case sensitivity... – Albert Oct 6 '15 at 12:37
  • The names are exactly the same in both tables, there's no spaces – AndM Oct 6 '15 at 12:51
  • Do the field types of common field match? – Farid Cheraghi Oct 7 '15 at 12:28
  • Yes they are both type text – AndM Oct 7 '15 at 12:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.