How to combinate two data tables and keep the original match and unmatched rows?

AT — Sat, 10 Jun 2023 23:58:32 GMT

Hi,

I have two data tables (f1 and f2). I like to compare f1 with f2 and create a new table f3 so that f3 merges the two tables with a match column. If any row is not matched, include the matched and not matched rows. I have attached data table f1 and f2 and what I like to have for data table f3. I have JMP PRO 15.

I appreciate your help here.

Thanks

Adam

Re: How to combinate two data tables and keep the original match and unmatched rows?

txnelson — Mon, 19 Dec 2022 03:08:17 GMT

Use Table=>Join and setup the dialog as below

And you will get the following table

topic How to combinate two data tables and keep the original match and unmatched rows? in Discussions

How to combinate two data tables and keep the original match and unmatched rows?

Re: How to combinate two data tables and keep the original match and unmatched rows?