Change variable names in a table

Hi all,

I would like to change all variable names within a table, to attached file, a cell array.

This is what i use now;

rf1.Properties.VariableNames = vars1

[Stephen23]

Since R2020a see also:

https://www.mathworks.com/help/matlab/ref/table.renamevars.html

Answer 1

[Stephen23]

You can use a cell array of names, like this:

rfi.Properties.VariableNames = {'name1','name2',...}

See: https://www.mathworks.com/matlabcentral/answers/179129-is-it-possible-to-rename-columns-in-a-table#answer_168467

[Jesse]

In this way i have to set the names manually. The names i want to assign are from another table...

[Guillaume]

What is the problem?

rfi.Properties.VariableNames = yourothertable.Properties.VariableNames

as long as both tables have the same number of variables obviously. If not, you'd have to add/remove elements to the cell array returned by yourothertable.Properties.VariableNames.

[Stephen23]

"In this way i have to set the names manually"

Nope. The names must be in a cell array or a string array, and while you could define that array manually, it is certainly not required. Why not just get the names of the other table using this:

C = othertable.Properties.VariableNames
rfi.Properties.VariableNames = C

[Sampath Rachumallu]

Unable to add spaces in Column names of a table using above.

[Steven Lord]

The ability to have spaces in table variable names was introduced in release R2019b as stated in the Release Notes.