Want to replace the value in datatable

[shirin.sebatina]

Hi ,

I am checking if the column has value or no, if value is present i need to ignore and if it is black them i have to write “WO” in that row.

Solution please!!!

[Gokul001 (Gokul Balaji)]

Hi @shirin.sebatina

You can try to give condition like

Excel application scope → Give excel path

Read range Activity → Enter the sheet name

Create an out datatable in the properties panel (DTOutput)

Use For each row in DataTable

Use If condition → Row(“Column Name”).ToString.Equals(“”)

If Then

Use Assign activity

LHS - Row(“Column Name")
RHS - “WO”

Use Write range activity

Hope it will works

Regards
Gokul

[ppr (Peter Preuss)]

for the different options of updating a data column vlaue have a look here:
How to Update Data Column Values of a Data Table | Community Blog

for checking w.g. within an if condition we can do
isNothing(theColumnValue) OrElse String.IsNullOrEmpty(theColumnValue.toString.Trim)
will return true if value is blank

Let us know your further questions