How do I insert numbers from column H to column G?

[Perawat]

Hello everyone,

The number condition of column G changes the line. Based on the information I receive each day.

Test.xlsx (10.6 KB)

Thanks.
Perawat

[Priyanka_Ramesh]

Hi ,
Can you please explain the Scenario in Detail ?

[samir (Samir Mohite)]

HI @Perawat,

Follow the steps below,

1. Read range and op var DT
2. use For each row on DT and inside it use If activity with condition —> String.IsNullOrEmpty(row("Credit Amount").ToString.Trim) —> to ensure column Credit Amount has no value.
3. Use follow 2 assigns in Else part of the If (Else because if there’s value then only we have to transfer it to column debit)
   row("Debit Amount") = row("Credit Amount") —> to get value from credit and assign it to debit column
   row("Credit Amount") = "" —> to delete value from credit col
4. Write range with DT

Here’s the workflow, in case you didn’t get the above steps.
—>Test.zip (25.0 KB)

[Perawat]

@Priyanka_Ramesh, When finding for numbers in column H. I want to add numbers to column G.

[Perawat]

@samir, Thank you so much for your help.