Comparing names in two cells in two different datatables

[John_Dara (Oluwadara John)]

Hi,
I’m having issues trying to incorporate name comparison in a workflow Testuse.xaml (24.3 KB) that compares the values of the amount column after comparing the ID’s.
I want to also check if the first and last name in Schedule Sent.xlsx (9.5 KB) are found in schedule received.xlsx (9.7 KB) and give a comment in the last column

[ppr (Peter Preuss)]

@John_Dara
this can be done with a Join

have an inital introduction here (Example with Join Datatable Activity and LINQ)
DT_Join_1Col.xaml (10.0 KB)

[John_Dara (Oluwadara John)]

Hi @ppr
How do i do the comparison for the test data i uploaded

[ppr (Peter Preuss)]

@John_Dara
have a look on this demo xaml:
FullJoin_1Col_JoinActivity_MatchResult.xaml (12.6 KB)

if you need further help for your case then give us a clear description on expected output (columnstructure, match result column …)

[John_Dara (Oluwadara John)]

@ppr
Here’s a sample result

[Vishal_K]

Hi @John_Dara

You can consider viewing this post:

Datatable comparison using multiple columns

Hi @John_Dara Following the attached workflow created using the Linq queries with minimal activities. Used the received and sent excel attached by you in your question Used Join datatable with full outer join to join receive and sent files Used the following linq query to update the both amount_remarks and name_remarks at a shot (From d In dtNewBuild.AsEnumerable Let amount_remarks = If( CDbl(d(“Amount_Sent”))=0, “Amount not sent”, If(CDbl(d(“Amount_Credited”))=0, “Amount not credited”, If…