https://community.jmp.com/t5/Discussions/Joining-Multiple-Data-Tables/m-p/409307#M65907 <P>Thank you for your kindness!</P> Thu, 12 Aug 2021 19:59:35 GMT marshmadness98 2021-08-12T19:59:35Z https://community.jmp.com/t5/Discussions/Joining-Multiple-Data-Tables/m-p/409183#M65894 <P>Hiya!</P><P>&nbsp;</P><P>I am having issues merging these two data tables. For some reason, every way I merge them, I end up with 60,000+ rows. I know I should be able to just join the tables or update the information from table two into table one, but I am stuck. I thought of trying the Query builder, but I am confused, and I also do not know how to code so I cannot join the tables that way.&nbsp;</P><P>&nbsp;</P><P>Thoughts?</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 10 Jun 2023 23:35:22 GMT https://community.jmp.com/t5/Discussions/Joining-Multiple-Data-Tables/m-p/409183#M65894 marshmadness98 2023-06-10T23:35:22Z https://community.jmp.com/t5/Discussions/Joining-Multiple-Data-Tables/m-p/409231#M65897 <P>Try using Join and Match with two columns:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1628783526413.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/34968i7CAFFFABA2C83D18/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1628783526413.png" alt="jthi_0-1628783526413.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1628783554146.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/34969i337F9DEE92436D8C/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1628783554146.png" alt="jthi_1-1628783554146.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 12 Aug 2021 15:53:31 GMT https://community.jmp.com/t5/Discussions/Joining-Multiple-Data-Tables/m-p/409231#M65897 jthi 2021-08-12T15:53:31Z https://community.jmp.com/t5/Discussions/Joining-Multiple-Data-Tables/m-p/409307#M65907 <P>Thank you for your kindness!</P> Thu, 12 Aug 2021 19:59:35 GMT https://community.jmp.com/t5/Discussions/Joining-Multiple-Data-Tables/m-p/409307#M65907 marshmadness98 2021-08-12T19:59:35Z