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
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
you can try this way by using the activites
if - condtion
CurrentRow("Manual Calculation value").ToString=CurrentRow("Actual Value fetching from Application").ToString
Hi its nit working, Its not considering then block directly it printing which we have mentioned in else block.
Hi Yochi, Could you pls help on this
Hi palaniyappan, if possible could you pls post a screenshot as well
CurrentRow("Manual Calculation value").ToString.Trim.Equals(CurrentRow("Actual Value fetching from Application").ToString)
can you try this one it will work
will try and update praveen, Thanks
Hi Praveen, I have tried then also in if condition its comparing then block its directly going with else and giving the status