How To Compare Expected value and Actual value and Update status in Excel by using Studio

Help Studio
, ,
1

Hi All,
How To Compare Expected value and Actual value and Update status in Excel by using Studio.
EG: In Column A given Manual Calculation value as expected, In Column B Actual Value fetching from Application, In Column C its need to compare Column A and B and Need to update Status in Column C

1 Like
2

Hi

Try with this expression in a assign activity on datatable u have read

dt= dt.AsEnumerable().ToList().ForEach(Sub(row) 
    row("Status") = If(row("Expected").ToString() = row("Actual").ToString(), "Match", "Mismatch")
End Sub)

Hope this helps

Cheers @Saajan_Venkatraman

3

Hi @Saajan_Venkatraman

you can try this way by using the activites

if - condtion

CurrentRow("Manual Calculation value").ToString=CurrentRow("Actual Value fetching from Application").ToString

image
image900×640 26.5 KB

4

Hi its nit working, Its not considering then block directly it printing which we have mentioned in else block.

5

Hi Yochi, Could you pls help on this

6

Hi palaniyappan, if possible could you pls post a screenshot as well

7 
CurrentRow("Manual Calculation value").ToString.Trim.Equals(CurrentRow("Actual Value fetching from Application").ToString)

can you try this one it will work

@Saajan_Venkatraman

8

will try and update praveen, Thanks

9

image
Hi Praveen, I have tried then also in if condition its comparing then block its directly going with else and giving the status