Input data into last row data with some condition

Help Studio
1

Hi All , I have the issue to input data in to last row data table excel from another excel with some condition as below

  1. If “Month Rate” from DT1 equal with “Month Rate” DT2 and "Different “Value rate” . Then Value rate from DT2 wil be replaced into DT1

  2. If “Month Rate” from DT1 not equal with “Month Rate” DT2 . then Dt2 data will copy to Last row+1 from DT1

image
image1078×437 20.9 KB

2

my meaning Condition 1

“Month rate” + Rate (DT1) = “Month rate” + Rate (DT2)