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

Hello everyone,

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

Test.xlsx (10.6 KB)


Hi ,
Can you please explain the Scenario in Detail ?

1 Like

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.
—> (25.0 KB)


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

@samir, Thank you so much for your help.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.