JOIN TOOL - after joining two data sets, null values come up

[EtamSoko]

hi Guys,

Until now I have always found a solution to my issues - thanks to all of you - but this time no success.

The problem: I have 2 data sets which I want to join based on a common service order number. On the left side BEFORE joining I have G/L codes in the following format:

AFTER joining together, all fields in the same column comes up as null:

I have tried almost every variation of string types but the problem still exists.

Am I overlooking something basic here?

I have also tried dividing into 3 columns this field using text to column tool and tried to join that way,but again no success.

I would really appreciate your help on this.

Thanks,

MK

[JosephSerpis · Accepted solution]

Hi @EtamSoko I think you first issue is the Null values in the GL accounts are being joined with other nulls so I would filter out the Null first before the join and that will help troubleshoot the issue with your join.

[fmvizcaino]

Hi @EtamSoko ,

Only complementing the @JosephSerpis response, you are seeing only null values in your column because you are looking for a sample of your data only, if you insert a browse after your join output, you will possibly see the values joined.

Best,

Fernando V.

[DiganP]

@EtamSoko As @JosephSerpis suggested, I would use the filter tool to filter out the nulls. You can also use the browse tool after the join to take a look at the full dataset. You will see the records that joined below the null values. 

Let us know if this worked or not. 

[EtamSoko]

thanks for all of you. it works now 🙂

[Pkoziol]

-User removed the comment-