How to change all cell values that do not equal "Complete" to "In Complete" using Studio X

[vielesh]

Hello,

I want to change all cell values that do not equal “ Complete “ to “Not Complete.” I tried using and an “IF”, “ Write Cell” and “Replace” activities but it is not working. I am using Studio X.

[Yoichi]

Hi,

Can you try ForEachExcelRow activity instead of WriteCell as the following post?

How to remove all text values from numeric value column in Excel using Studio X

Hi, Can you try as the following? [image] The condition is as the following in Advaned Editor CurrentRow("EmployeeID").ToString.IsNumeric() = false Regards,

Regards,

[Anil_G (Anil Gorthi)]

Hi @vielesh

Add a for each row in excel

Then use a if condition with
Not currentRow("ColumnName").ToString.Trim.Equals("Complete")

Inside then use a set variable

currentRow("ColumnName") = "In Complete"

Leave else blank

Cheers

[vielesh]

@Anil_G

Not currentRow(“ColumnName”).ToString.Trim.Equals(“Complete”)

Hi,
Thanks for the response. It’s still not working for me. Are you able to take a screen shot in studio x ?
Best

[Yoichi]

Hi,

Can you try the following sample?

Workflow

Result

NewBlankTask20221213-1.zip (62.6 KB)

Hope this helps you.

Regards,

[vielesh]

Thanks so much it worked!

Best