Fill empty rows of specific column with value

Help
, ,
1

Hello,

I’d like to add the same value on all empty rows of a specific column of a datatable.

From:

image
image843×265 9 KB

To:

image
image846×263 9.74 KB

2

use if condition like this
row(“Budget request”).ToString = “”
in then part use assign activity like this row(“Budget request”) = “No reply”

cheers
@RailCay

3 Likes
3

@Pradeep_Shiv

It worked but the ‘$’ got lost on the other rows.

What to do to not removed ‘$’ sign?

1 Like
4

oh!
can i see your workflow what you are trying to do?
@RailCay

5

@Pradeep_Shiv

Here:
AddValuetoEmptyRowsofSpecificColumn.zip (21.9 KB)

6

To not lose $ sign you can use activity Write Cell to only record value in empty cells.

  1. Read range of your excel file to datatable (e.g. MainDataTable)
  2. Iterate through it and check if the cell is empty using If activity. If empty, use Write Cell activity. In your case the cell will be:
    “E” + (MainDataTable.Rows.IndexOf(row)+1).ToString
  3. As value put “No reply”

Please let me know if you need better explanation

7

Hello, when I tried this, I received an error message saying “Assign: Exception has been thrown by the target of an invocation”. Do you know what could be causing it?