How do you remove a value from a table based on its value

I am trying to remove the columns from the tollowing Combined table if they have a Value of 1.

I am a trying to find a method that deletes the colunn based on its value rather than deleting the column based on its heading, as it value may change to a 1 or 0 depending on the data set.

This is what I currently have but I am recieving the following error. If anyone has any advice that would be great!

Value = ([0,0,1,1,0])

Value = 1×5

0 0 1 1 0

Heading = (["Radius", "Speed", "Type", "Location", "ID"])

Heading = 1×5 string array
    "Radius"    "Speed"    "Type"    "Location"    "ID"

Combined = array2table([Value; Heading])

Combined = 2×5 table
      Var1       Var2       Var3        Var4       Var5
    ________    _______    ______    __________    ____

    "0"         "0"        "1"       "1"           "0" 
    "Radius"    "Speed"    "Type"    "Location"    "ID"

Combined(Combined(1,:)>0,:) = []

Error using >
Applying the function 'gt' to the variable 'Var1' generated an error.

Caused by:
Error using >
Comparison between string and double is not supported.

[VBBV]

% first approach  & simpler
Value = ([0,0,1,1,0]);
idx = Value > 0;
Heading = (["Radius", "Speed", "Type", "Location", "ID"]);
Combined = array2table([Value; Heading]);
Combined(:,idx) = []

Combined = 2×3 table
      Var1       Var2      Var5
    ________    _______    ____

    "0"         "0"        "0" 
    "Radius"    "Speed"    "ID"

% second approach using additional functions  
Value = ([0,0,1,1,0]);
Heading = (["Radius", "Speed", "Type", "Location", "ID"]);
Combined = array2table([Value; Heading]);
idx = str2double(table2array(Combined(1,:))) > 0 

idx = 1×5 logical array
   0   0   1   1   0

Combined(:,idx) = []

Combined = 2×3 table
      Var1       Var2      Var5
    ________    _______    ____

    "0"         "0"        "0" 
    "Radius"    "Speed"    "ID"

[Daniel Gaggini]

Thank you very much for your time and your answer.

Answer 1

[the cyclist]

One can do what you ask as follows:

Value = ([0,0,1,1,0]);
Heading = (["Radius", "Speed", "Type", "Location", "ID"]);
Combined = array2table([Value; Heading]);

Combined(:,Combined{1,:} == "1") = []

Combined = 2×3 table
      Var1       Var2      Var5
    ________    _______    ____

    "0"         "0"        "0" 
    "Radius"    "Speed"    "ID"

In your simple example, MATLAB had to convert the numeric values 0 and 1 to the strings "0" and "1", to store them in the same column with other strings.

[the cyclist]

Also, I can't shake the feeling that you are storing your data in a table in a very unconventional way, and therefore will experience many of these awkward operations. I suggest learning about the tidy format.

[Daniel Gaggini]

Thank you very much for your time and your answer. Also thanks for the learning link. :)