Issue with a Join Tool - No Data After Join

[MatthewBr]

Has anyone had a join on one field - run there workflow and Nothing shows up in the Left, Join or Right ?

[KarolinaRoza]

Hi @MatthewBr 

Could you share as well screen of configuration of Join Tool?

Regards,

Karolina

[Garabujo7]

Agree with @KarolinaRoza , would you share the config of the join tool?

Meamwhile take a look at the one tool sample of the join tool, it may be useful.

Gabriel

[MatthewBr]

[MatthewBr]

I mean anytime I have used a join and the connecting data (Key fields on the join) are the same format - At least some data falls in the left or right but I have never had a situation where no data flowed through the output side (L, J or R)

[Garabujo7]

Right @MatthewBr , that seems odd.

May you share some data to take a look myself?

[MatthewBr]

I unfortunately can not share the data. I apologize as I know this would help with the situation.

[Garabujo7]

Some dummy data, with a similar structure that yields the same result will make it. Just a handful of records will be useful just to replicate the issue.

[Maskell_Rascal]

Hi @MatthewBr 

I'm just spit balling here, but have you tried a Find/Replace to see if maybe your lookup file contains only part of the number from your original dataset?

The two screenshots you provided point me in this direction, since one has a length of 10 and the other a length of 8. 

[MatthewBr]

Even if the data was lengths of 10 and Length of 8 on the other - Doesn't explain why there is nothing appearing on other side of the join?