Updating 1 column if another column is blank

Help
1

I have two columns in my data table. The first may be blank and if so i want to update second column to display “Yes”.

Image%201
Image%201599×519 25.2 KB

2

HI @jon1302

Try the below command and see whether it works

stJoinedCompanyName2.Equals("")

Let know how it goes for you

3

Additionally, in the assign, make you are updating the data table column. You are updating a variable. TO update do this

row("ColumnName") = "Yes"

4

Hi @jon1302,

Try making these changes
image

Later write to excel

Thanks,

5

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