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) an…

Comparing names in two cells in two different datatables

ppr (Peter Preuss) July 9, 2020, 7:21pm 2

@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)

1 Like

Datatable comparison using multiple columns

Topic		Replies	Views
Datatable comparison using multiple columns Studio excel	5	2585	July 16, 2020
Excel compare 2 Column Activities excel , activities , studio	9	735	October 10, 2022
Compare and join list matches and differences Activities excel , activities , studio	2	832	February 3, 2022
How to compare two column names in datatable and write data from one data table to another data table if column name is matched Help datatable , activities , question	1	1185	January 27, 2020
Compare two excel files(if any changes in values throw a msg) Help excel , activities , question	6	794	January 31, 2020