replace cell value based on the value of another column


I have two columns and I want to update the value of a few rows under Column 1 based on the corresponding row value under Column 2. Is there a way to do this?

>      col1    col2   
> 1    456     yes
> 2    789     yes
> 3             no
> 4             no

I want col1 row3 and row4 to say “N/A”. Basically, to check col2 for yes if found do nothing. else if no then update the corresponding col1 value to “N/A”

Hi @Adiwakar -

Check out the Rule Engine node:


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