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? 

TheMattLeonard

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