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