Forum Discussion
Error message when expanding second table in merge: "The 'offset' argument is out of range"
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.
Super User
Be good if you can provide some idea of the data you have, what is in the tables etc.
The tables that you are trying to expand - do they all have the same structure/number of columns?
When you get an offset error like this it means PQ is trying to refer to something that doesn't exist. Likely it thinks there a table column at row offset but it is't there.
The table in the first row might have 4 columns, but some subsequent row has a table with less than 3 columns.
Phil
Hi Phil,
I'm not sure what details would be most helpful, but the merge is a left join between two tables; the first table is a list of academic articles and associated details (year of article publication etc), put together from a couple of sources via previous merges. The second table is a list of academic journals and associated details. The theory is to join the tables, matching on journal identifier (ISSN), to bring the additional journal information into the list of articles as additional columns, so that each article has additional information about its respective journal added in. Both tables look fairly standard to me in terms of structure.