How to remove all rows from categorical variable corresponding to a double array?

Assuming the following data and Table X:

A=[ 1 5 0 3 9]';

B=[ 2 9 5 8 0 ]';

C={'S1','S2','S3','S4','S5'}';

C = categorical(C);

X = table(C,A,B);

...and removing the rows with zeros

A1 = A(A(:,1) > 0, :);

B1 = B(B(:,1) > 0, :);

How do I now remove the corresponding rows from C that were removed in A and B, and make a new table X1 that contains A1, B1, and C1? I know have have to using indexing to determine which categories of C correspond to the rows that were removed, I'm just not sure how to do that.

Answer 1

[Fangjun Jiang]

index=and(A(:,1) > 0,B(:,1) > 0)
X1=X(index,:)

[Anthony]

Thanks! That worked great.

Answer 2

[Peter Perkins]

You might find this more expressive, and it doesn't require the original vectors, which you may have chosen to delete afer putting them in the table X:

X2 = X(X.A>0 & X.B>0,:)