Forum Discussion
Solved
Error message when expanding second table in merge: "The 'offset' argument is out of range"
Hello all, I'm coming across a mysterious (to me) error message when I'm trying to run a left outer join to merge two queries together. The merge seemingly works well, but then when I seek to expand ...
Thank you Shubham_rai955 and PhilipTreacy for your suggestions. I've finally figured out the problem, and I think it is effectively an example that falls within the suggestions you've both made: the matching identifier being used, ISSN number, is often used in the format '1234-5678', which was the case in both of the tables here. Removing the hyphens from the ISSNs in both tables --> a nice obedient merge using the '12345678' identifiers. Phew! Thanks again.
Shubham_rai955
Super User
Super UserAC246 , if my solution helped you in any way, please mark it as solution
To be honest, I figured it out just before seeing your message.