Alteryx unable to recognise same code in one of two files

[jenki07]

hi community, I would appreciate your help. I am joining a field from two different files (one is .csv) that contain the same five digit code, so '2022 file' has 12345 and '2023 file' also has 12345. But when I join the files only the one code form 2023 file is showing in output. I've tried changing both fields to Int 64, VW string, V string, and using Trim but nothing is working.  Any clues how to solve this? 

[Prometheus]

@jenki07 Can you please post your workflow with some sample data? That makes it much easier for us to help you solve the issue. Thanks.

[TheMattLeonard · Accepted solution]

I'd recommend using the ToString() function on both sides, and also doing a data cleanse on both sides for any white space/punctuation.

I'd also just check your join tool. Are you joining on the correct fields and are you selecting the correct fields in the output? If only 2023 is outputting it could be that you deselected the 2022 field