Getting "Paid Status" to write to cell on current row and iterate to next one (for each item in row)

[chewyearth38 (George)]

Basically on a PCN Charge if the outstanding amount is 0 it means the charge has been Paid but any other amount means it is Unpaid and i want it to write either of those 2 words on the current row in coumn E (“Status”) i’ve assigned pIterate and it can go through each reg and Charge number but i want it to start on the row it reads from and then iterate to the next row when it reads and enters the next reg and pcn charge number. How would i go about this?

[Aakash_Singh_Rawat]

Hi,

Read sheet as datatable using read range activity.
Use for each row in that DT.
Check If CurrentRow(“yourColumnName”).ToString().equals(“0”):
take current index of loop,
use write cell activity to write on Status column, cell no. current index+2=Paid
else:
use write cell activity to write on Status column, cell no. current index+2=Unpaid

[chewyearth38 (George)]

hi so it gets the number from get text then assigns… i just want it to write the two word on the current row, its in a for each row

[Aakash_Singh_Rawat]

Use currentRow(“Status”)=“value to set” inside if/else of your loop.
Assumin you have status column in your DT.