Help with conditional statement

I'm trying to create a conditional statement, using the code below. This code attempts to replace the unit name with a new unit name if the CC Key is greater than zero; otherwise, use the previous unit name:

if any(Table1.CC_KEY == 0);

   Table1.NEW_UNITNAME = Table1.UNIT_NAME;

   else

   Table1.NEW_UNITNAME = Table1.UNIT_CC;

   end

[Adam]

So what is the question? Does it not work? If not what does it do wrong? You seem to be testing for equality against 0 yet your comment says it is testing > 0. I assume the key cannot be negative then.

[Mike Raymond]

Thanks! In my case, if the CC Key is greater than zero, then the previous unit name appears as the new unit name...and if the CC Key is zero, then the previous unit name appears as well. In others, regardless of the CC Key value, the previous unit name appears as the new name. Does this make sense?

Answer 1

[Steven Lord]

If I understand correctly what you want to do, you want to rename one of the variables in your table. Is that correct? If so you could assign the contents of that variable to another then delete the old variable, or you could just change the name of the variable.

Note that some of the functions listed on that first documentation page to which I linked were introduced fairly recently (the removevars function was added in release R2018a, for example) so they won't be available if you're using an older release. But I believe some of the deletion techniques as well as the variable renaming technique will work for all releases containing table.

[Mike Raymond]

Steven, much appreciated! Actually, I'd like to change the variable names only when the CC Key is greater than zero. Otherwise, I want to leave the variable names unchanged. So, unfortunately, I'm not sure this approach would work. Again, thanks for taking the time.