I was trying to join these two input files but somehow all my keyid turns out to be 0 after the join. i tried to change the data types of the joined fields but it did not work either. Anyone here could know the root cause and how to fix this?
Thanks,