Compare 2 different columns and the output in another column using linq query

Help Activities
, , ,
1

Hi all,

Linq.xlsx (8.6 KB)
Sheet 1 consists of
image
Sheet 2 consists of
image
Need to compare the Task name and Activity with 28 and Hours columns and the result should be
image
If the task name and hours are not same then need to give not match else match need to give.
How to do this using linq query, please help…

2

try below way

  1. read both the excels
  2. add data column for the second table
  3. Use invoke code activity and refer below thread to find the linq query

Finally write the datatable to excel

Regards

1 Like
3

find the file

testlookup.xaml (8.7 KB)

image
image902×723 35.1 KB 

For Each row1 As DataRow In dt1.Rows
	For Each row2 As DataRow In dt2.Rows
		If row1("Activity").ToString() = row2("Task Name").ToString() AndAlso row1("Hours").ToString() = row2("28").ToString() Then
		row1("Status") = "Matched"
		Exit For
		Else
		row1("Status") = "Not matched"
		End If
	Next
Next

Assuming Status column will be available other have to use add data column activity before invoke code

Regards

1 Like
4

Hi @lakshmi.mp

How about the following?

Initialize dtResult
image

Then read first excel as dtInput and read excel 2 as dt2
and then just filter

(From row In dtInput
Join row2 In dt2
On row("Task Name").ToString().Trim().ToUpper() Equals row2("Activity").ToString().Trim().ToUpper()
Let hours = If(row("Hours").ToString() = row2("Hours").ToString(), "Match", "Not Match")
Let ra = New Object(){row("Task Name"), row2("Hours"), hours}
Select dtResult.Rows.Add(ra)).CopyToDataTable

image
image822×597 17.8 KB

Result:
image

Regards!

5

Hi @fernando_zuluaga

image
image852×595 40.5 KB

can you check this, what is the issue…

6

Hi @lakshmi.mp

I told you to initialize your dtResult as i show above in the image with those 3 columns
image

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.