Comparing two values

[pabaleloh]

Good day please assist I have two excel files, so I need to copy the amount from V column—1138114—to the second file to determine whether it is an mtach or not. I do this by writing the amount in column C and the match status for each treaty in the row names column in column D.

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @pabaleloh

You can use filter datatable activity to filter based on the value 1138114.
if it will be just one row, you can use below expression to fetch the amount:

YourDataTableVariable.Rows(0).Item(“Column U”).ToString

And then use write cell activity to write the amount in other sheet in column C.

One you have copied amounts to column C, then run loop on another sheet datable, compare the columns and if match is found, write value in datatable column D.

[sarvesh.b (Sarvesh)]

Hi @pabaleloh

Can you please explain in more detail?

If you want to get that specific value use lookup range activity and give the range from V1 and pass the 1138114.

Then use read cell activity to read that cell value.

Us excel application scope to read the 2nd file write that value in C column. Use for each and assign both the columns to compare the values.

Thanks!!

[ashokkarale]

@pabaleloh,

Can you share a sample for this? Remember to replace sensitive data with dummy data.

[pabaleloh]

Thank you i am sorted