How to add columns with fixed values to their exact position in the table

Hello, I have a table with 16 columns. Some columns have variable value and some have fixed value.

I fixed their values like:

simtable.datacenters(:)="Cloud_1";

Now, This column is at no. 4 in my table. but, when printing output it gets printed at last.

I also want to generate its excel sheet but the columns with fixed values are not added to excel sheet.

Thank you.

Answer 1

[Abderrahim. B]

Hi,

Use addvars instead of dot notation to add columns to your table.

Demo:

load patients
T = table(Age,Gender,Smoker) ;

% add a new column to T table before Age 
T = addvars(T,LastName,'Before','Age')

T = 100×4 table
      LastName      Age      Gender      Smoker
    ____________    ___    __________    ______

    {'Smith'   }    38     {'Male'  }    true  
    {'Johnson' }    43     {'Male'  }    false 
    {'Williams'}    38     {'Female'}    false 
    {'Jones'   }    40     {'Female'}    false 
    {'Brown'   }    49     {'Female'}    false 
    {'Davis'   }    46     {'Female'}    false 
    {'Miller'  }    33     {'Female'}    true  
    {'Wilson'  }    40     {'Male'  }    false 
    {'Moore'   }    28     {'Male'  }    false 
    {'Taylor'  }    31     {'Female'}    false 
    {'Anderson'}    45     {'Female'}    false 
    {'Thomas'  }    42     {'Female'}    false 
    {'Jackson' }    25     {'Male'  }    false 
    {'White'   }    39     {'Male'  }    true  
    {'Harris'  }    36     {'Female'}    false 
    {'Martin'  }    48     {'Male'  }    true  

Hope this helps

[Akashdeep Kaur]

Thank you, I still have

simtable.IoTLayerName(:)="IOT_1"

to fix column value. but when i use

simtable = addvars(simtable,IoTLayerName,'Before','IoTLet_MI')

It gives me error:

Unrecognized function or variable 'IoTLayerName'.

[Abderrahim. B]

Unrecognized function or variable 'IoTLayerName' means that the variable (IoTLayerName) that you are trying to add to the table does not exist.

To check if a variable exist or not use exist function.

Example:

a = 4 ;

% does variable a exist? The answer is yes
% to check.
exist('a','var')

ans = 1

% does variable IoTLayerName exist ?  The answer is no.
exist('IoTLayerName','var')

ans = 0

[Akashdeep Kaur]

The answer is zero. It does not exist.

Is there any alternative to fix column value with a string?

[Abderrahim. B]

What do you mean by fix column value with a string ?

[Akashdeep Kaur]

In table simtable some columns have variable value i.e., allocated using loop. but some have fixed cell value. If there are 16 rows then for column 'IoTLayerName' the value for all cells is ''IOT_1''

[Abderrahim. B]

You meant to say by 'variable value ' variable length, right? are you getting an error? if yes, pelase share it. Thanks

[Akashdeep Kaur]

No, by variable value i meant rows have different data in them for some columns. but For some columns data has been fixed i.e., for each row for that particular column the data is same string.

MELOutputData_Mb=MELOutputData_Mb(:) % converting array into column

simtable.VmName(:)="VM_1" % fixed column data

Now, when i display the table using

simtable

i get everything correctly. but 1. when i write it into excel sheet

simtable.VmName(:)="VM_1" % fixed column data

columns like these donot get written.

Thank you for coping.

[Abderrahim. B]

Created the example below, it s working just fine:

clear 

% Create a dummy simetable
simetable = table(["A"; "B"; "C"; "D"]) ;

% Add column with that rows has same string
simetable = addvars(simetable, repmat("VM_1", 4,1)) ;
writetable(simetable, "simetable.xlsx")

Try to write to text file maybe!

Another solution is to convert to categorical then write to excel spreadsheet

writetable(array2table(categorical(table2array(simetable))), "simetable_sol2.xlsx")

[Akashdeep Kaur]

Instead of using

simtable.VmName(:)="VM_1" % fixed column data

now i am using

datacenters=repmat("Cloud_1",1,zx);

as suggested by you and the problem is solved.

Thank you for your time and effort.

[Abderrahim. B]

My pleasure .

Good luck