Join Tool - Degradation of Data

[ZoeM]

Hi Alteryx SME's.

Ive used my workflow for 5 years now and I am challenged by a Join Tool which is some records in a field are missing, not all records but some. 

Nothing has changed from the fields that were being used to Join Data. And the field experiencing the loss of data is string field not being used to join.

Has anyone expereinced this before and any ideas on how to resolve? Unfortunately I can not provide a sample and would not be able to duplicate. 

Thanks!

[ZoeM]

No I have not tried that. What is interesting is that the server copy has no issues, only my desktop version and I hadnt made any changes that would have caused this.

[AndrewDMerrill]

This may require filing a support ticket then.

[ZoeM]

So I am still working through this hence why I have not marked it yet. I did however bypass the Join with the field giving me issues by bringin it in at the end of the workflow and seems to have solved that issue. However, created another slueth of issues I am correcting 🤔