Get row value based on column value

[vineelag (vineela27)]

hi @quentin.catin

can you tell me in detail.

[quentin.catin]

Hello @vineelag, not sure to be the right person

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

@vineelag

Thank you so much but i need to compare once excel value in another excel value

for each excel1 value if its contains excel2 or not if yes need to increase the count by adding one (example age is 33 and its from excel1 and contains excel2 so need to increase the final count be 34)

you answer partially correct but need to compare two excels value.

Please let me for this.

Oh, I need your input and expect output
I will edit code

[vineelag (vineela27)]

@Nguyen_Van_Luong1

sure will share with you.

[vineelag (vineela27)]

Hi @Nguyen_Van_Luong1

Thank you!!!

in my case i have excel1(Today)

Exce1(Today) you can see below

as you can see in excel1(today) from this excel we will take each account and check that account in Excel2(Masterfile)

Excel2(Masterfile) You can see below img

need logic for

Each account i need to check in Excel2(Masterfile) if its contains Excel1 account(45398719) in excel2(Master file) then i need to Increase the count value+1(for this account 1+1=2 the count value is 2)

i was attached the file with this, kindly let me know the output for this.

Thank you!!!

Excel2.xlsx (9.3 KB)
Excel1.xlsx (9.1 KB)

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @vineelag ,
I used activity to compare
you can check
Sequence.xaml (21.1 KB)

[vineelag (vineela27)]

HI @Nguyen_Van_Luong1

Its working awesomely, but its taking more time for each transection because its looping each account in excel2(Masterfile)

per day i am getting 15000 transection is there any another alternative simple code for to save time.

Thank you!!!

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

I think LinQ can be faster
I haven’t tried it yet
But I 15000 row are not problems
How long does it take on your machine?
I didn’t see it for too long

[vineelag (vineela27)]

@Nguyen_Van_Luong1
For 100 transections its taking 2 hrs peroxyl.

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

oh, in your file send to you have 10 rows, it take 1s to complete
I think 15000 is not problem
but we can think use LINQ

[vineelag (vineela27)]

how can i use LINQ code

’ Read the first Excel file into a DataTable
Dim dtFirstFile As DataTable = New DataTable()
dtFirstFile = ExcelApplicationScope1.ReadRange(“Sheet1”)

’ Read the second Excel file into a DataTable
Dim dtSecondFile As DataTable = New DataTable()
dtSecondFile = ExcelApplicationScope2.ReadRange(“Sheet1”)

’ Extract the values from the DataTables into lists
Dim valuesInFirstFile = dtFirstFile.AsEnumerable().Select(Function(row) row.Field(Of String)(“Name”)).ToList()
Dim valuesInSecondFile = dtSecondFile.AsEnumerable().Select(Function(row) row.Field(Of String)(“Name”)).ToList()

’ Find common values using LINQ
Dim commonValues = valuesInFirstFile.Intersect(valuesInSecondFile)

’ Loop through the common values and perform actions
For Each commonValue In commonValues
LogMessage("Common value: " & commonValue)
Next

But i am not sure about it.
please kindly guide me on this.