Compare two Columns in Datatable Using Linq

Help Activities
, , ,
1

Hello Friends,

I have Two Columns(Reference and External) of Data two compare as below

This image shows an Excel spreadsheet with columns for Reference, External, and Result, containing various numerical values. (Captioned by AI)

Need to Compare Reference Column and External column and to write results in Result Column as below

{74A21739-7958-4896-99A9-F800726BAFE6}

How to achieve this, Anyone kindly suggest me on this, Thanks

2

Can you share the excel file?

3

Hi @Akash_Javalekar1 Thanks for the reply, Pls refer the Screenshot which is same as excel

4

Hi @Manii_K,

You can use linq or invoke code to acheive this.
Sharing the workflow with invoke code. Please try and let me know if it works.
Code.txt (1.9 KB)
Main.xaml (23.2 KB)

The image shows a UiPath workflow with activities and output panels, displaying a data table comparison result based on partial matching of numerical identifiers. (Captioned by AI)
The image shows a UiPath workflow with activities and output panels, displaying a data table comparison result based on partial matching of numerical identifiers. (Captioned by AI)1413×870 42.9 KB

5

Thanks for your valuable solution @rashmisingh2695, I’ll try and let you know

6

Here’s another solution; I’ve included more failure modes

image

image
image1249×5311 393 KB

image

7

Hi @Manii_K
Here is my solution
Workflow.zip (3.0 KB)

The image displays an active debugging session in a development environment showing the start of a test execution along with matched and unmatched results based on sequence number comparisons. (Captioned by AI)
The image displays an active debugging session in a development environment showing the start of a test execution along with matched and unmatched results based on sequence number comparisons. (Captioned by AI)420×973 22 KB

8

Hi @sudster, Can I get this workflow xaml

9

@Manii_K , here it is:

DTCompare2Cols.xaml (27.8 KB)