Hi,
I want to rewrite a column in my database so that if there is a value in that column it will become 1 and 0 otherwise. I’m using the excel filter but I’m having this error “Operand NOTEMPTY does not take an operator”
Hi @ivory_le
Filter is only used to filter data based on certain conditions/values, not to rewrite the values when a particular value is found.
To rewrite values when a certain value is found, you can use find/replace activity.
Hey @ivory_le can you use for each row and inside for each pass this logic
row(“MyColumn”) = If(String.IsNullOrWhiteSpace(row(“MyColumn”).ToString), 0, 1)
cheers