Compare two datatables and find the match

Help Studio
,
1

Hi,
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

image

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

image

SplitExcelCellValues.xaml (25.8 KB)

3
  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