During Join: Unable to allocate enough memory error message

[#1]

When joining tables, get "Unable to allocate enough memory" error or "Join failed".  IT told me to ask JMP what to do.  Many Thanks.

[#2]

Hi, jyedlinski1!

It sounds to me like you need more memory in your computer, but some more information might be helpful.

What type of join are you trying to perform?  How big a table (rows and columns) are you trying to join to how big a table?  How much memory do you currently have?  What version of JMP?  What OS?  

I would also recommend submitting your question to JMP Support.

[#3]

Thanks!

Table A: 118 MB, Rows=221341, Col=39

Table B: 146 MB, Rows=236758, Col=45

[#4 · Accepted solution]

If in fact insufficient RAM is the culprit, one technique you might want to try, if you are running JMP 13, is JMP 13's Virtual Join capability. One of the attractive design features of this capability is to reduce the memory footprint of two or more JMP data tables that are required for some analysis purpose. Here's a link to the JMP online documentation for the Virtual Join capability:

https://www.jmp.com/support/help/13-2/Virtually_Join_Data_Tables.shtml

[#5 · Accepted solution]

make sure you are not doing a cartesian join, which would make nrows(a)*nrows(b) rows.