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

[#1]

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

[#2]

Use Table=>Join and setup the dialog as below

And you will get the following table