Replacing individual Values in Data column based on a condition

Hello!

I am new to matlab and programming in generall. I have been working with a large data table. I have a few outliers in one o the columns and would like to replace them with the value 1.

However, I keep getting the error "Right hand side of an assignment into a table must be another table or a cell array."

Here is my code. Any help is appreciated!

 myData=db_data.dataTable;
 myData(myData.fluid_p_rel<0.9,:)=[1];
 myData(myData.fluid_p_rel>1.2,:)=[1];
 

Answer 1

[Stephen23]

idx = myData.fluid_p_rel<0.9 | myData.fluid_p_rel>1.2;
myData.fluid_p_rel(idx) = 1

[JessHmann]

Thank you! :)