How to join two datatables and get duplicate and non duplicate items in column 1 from both datatables

@Karan28
Find some quick prototype as starter help here, based on a generic dataset
Join_1Col_MergeBoth_AddCols.xaml (11.0 KB)

Just give a play by renaming the column names as by your case.

  • check also the ColList variable, for configuring the final result list columns
  • Constraints: Join Col to keep is the first column from Join DataTable

A later more dynamizing should be possible

1 Like