Compare two datatables and find the match

I have two data tables, having two columns.
i need to compare the column(Voluntary Deduction) and find the match and update it to true.
image image


I have tried but when it is not matching, it giving the output as blank.


SplitExcelCellValues.xaml (25.8 KB)

  1. Use Build Data Table to create the structure of your final table
  2. For Each Row in you first table
    2.1 Lookup Data Table to your second table
    2.2 Update the final data table accordingly
1 Like