Welcome to the forum.
I think the first thing we need is some sample data from both files . A handy way to supply sample data is to use the dput() function. See ?dput. If you have a very large data set then something like head(dput(myfile), 100) will likely supply enough data for us to work with.
For general information on how to ask questions, data and code formatting and so on please have a look at FAQ: How to do a minimal reproducible example ( reprex ) for beginners