Want to replace the value in datatable

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!!!

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


1 Like

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

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