How to create a number of output tables at each iteration ?

Dear altruists,

Seek suggestion.

I have a "TW" table where TW(:,1) = start row number and TW(:,2) = end row number is mentioned.

I have a "D" table where raw data is present. D is a table which has 1 to 15,000 rows and 10 cols. For each iteration, I have to pick values from "D" table ( copy) with specified rows & cols. and drop it to an output table (paste them) and the requirement is that the output data table name will be change from Z1.........Z20.

I want to output various table for every iteration.

For example,

i =1 will create output table Z1 = D(rows, cols)

i = 2 will create output table Z2 = D(rows, cols)

.

.

i =20 will create output table Z20 = D(rows, cols)

**************************************************************************

for i = 1 : 20 
    cols = [1 2 5 7];
    rows = TW(i,1):(TW(i,2));
    Z = D(rows,cols);
end

[Image Analyst]

And what about when i = 3 through 20?

Have you ever seen the rem or mod function? If you use that you can toggle between setting Z1 and Z2.

for row = 1 : height(TW)
    cols = [1 2 5 7];
    rows = TW(i,1) : TW(i,2);
    if rem(row, 2) == 1
        Z1(row, 1) = D(rows, cols);
    else
        Z2(row, 1) = D(rows, cols);
    end
end

[MD Rabiul Islam]

Thanks for your reply. I clarified my question. Can I request to have a look ?

[Stephen23]

"Dear altruists... the output data table name will be change from Z1.........Z20."

https://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval

[MD Rabiul Islam]

I also find this comment during googling...Can I request any alternative easiest solution to do this ?

[Stephen23]

"Can I request any alternative easiest solution to do this ?"

Indexing.

Answer 1

[Abhishek Chakram]

Hi MD Rabiul Islam.

It is my understanding that you are facing difficulty to extract multiple rows and columns from a bigger table and store it in multiple named variables. As a workaround, you can create a cell array to achieve a similar result. Here is an example for the same:

Z={};
for i = 1 : 20 
    cols = [1 2 5 7];
    rows = TW(i,1):(TW(i,2));
    Z{i} = D(rows,cols);
end

In this example, "Z" is a cell array. You can access each sub table using indexing as shown below:

Z{1}
Z{2}

You can refer to the following documentation to know more about the functions used:

• Cell array: https://www.mathworks.com/help/matlab/ref/cell.html

Best Regards,

Abhishek Chakram

[Stephen23]

Also: https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-cell-array.html