Compare two column values in the same excel and it should return a output value

Help Studio
, ,
1

In Excel, I have two columns with the same type of values and I need to compare the values and it should return an output value based on the comparison.

Ex:
image

I have columns A and Column B with the string data type, by comparing the values I need to get the status either “True” or “False”.

2

@Suresh_Eadula

use this Linq

dt.AsEnumerable.ToList.ForEach(Sub(row) row("Status") = If(row("Actual value").ToString.Equals(row("Expected Value").ToString), "True", "False"))

3

@Suresh_Eadula

Welcome to the community

you can use excel formula

"=IF(A2=B2,""TRUE"",""FALSE"")"

Then use auto fill range

if you want to do in datatable then use as below in invoke code

pass dt as in/out argument with datatable type

dt.AsEnumerable.ToList.ForEach(sub(r) r("Status") = If(r(0).ToString.Trim.ToLower.Equals(r(1).ToString.Trim.ToLower),"TRUE","FALSE"))

cheers

4

I Tried like below. But the control always going

UIpath_logic
UIpath_logic736×528 20.2 KB

to else condition.

5

@Suresh_Eadula

you also try in this way

dt=dt.AsEnumerable.Select(Function(a) dt.Clone.LoadDataRow({a(0).ToString,a(1).ToString,If(a(0).tostring.trim.equals(a(1).tostring.trim),“True”,“False”)},False)).CopyToDataTable

hope this helps

6

@Suresh_Eadula

you need to pass like this

CurrentRow(“ActualAmountPayable”).tostring.trim.equals(CurrentRow(“Manual Calculation”).tostring.trim)

or

CurrentRow(“ActualAmountPayable”).tostring.trim=CurrentRow(“Manual Calculation”).tostring.trim

7

@Suresh_Eadula

Try with currentRow("Column1").ToString.Trim.Tolower.Equals(currentRow("Column2").ToString.ToLower.Trim)

but one issue with your aaproach is how do you change the row values?

if you use auto increment it will not work as expected as two separate activities of write cell are used

please try the above specified approaches

cheers

8

@Suresh_Eadula

dt1.AsEnumerable().Select(Function(x) If(x(0).ToString().Equals(x(1).ToString()), FilterDt.Clone().LoadDataRow({x(0).ToString(), x(1).ToString(), “True”}, False), FilterDt.Clone().LoadDataRow({x(0).ToString(), x(1).ToString(), “False”}, False))).CopyToDataTable

image
image1008×506 8.77 KB

Cheers!!

9

You can try this in Invoke Code

For Each r As DataRow In in_dt.AsEnumerable()
r("Status")=If(r("ActualValue").ToString.Equals(r("ExpectedValue").ToString),True,False)
next r

image
image1027×700 27.6 KB

Output: -

image
@Suresh_Eadula

10

Thanks, @Shiva_Nikhil it worked.

1 Like