Sort table by two columns using column name

Hello!

I can sort a table with: sortrows(tableName, 'columnName1').

I can also sort the same table by 2 columns using: sortrows(tableName,[columnNumber1 columnNumber2])

How can I sort the table by 2 columns using column name?

The following does not work: sortrows(tableName, ['columnName1' 'columnName2']). I get an error saying "unrecognized variable name 'columnName1ColumnName2'.

Thanks in advance!

[madhan ravi]

upload your table

[Peter Perkins]

The issue here is that ['columnName1' 'columnName2'] concatenates those two char row vectors to make one long one. As Chris says, you need either a cell array of char row vectors

>> {'columnName1' 'columnName2'}
ans =
  1×2 cell array
    {'columnName1'}    {'columnName2'}

or in recent versions of MATLAB, a string array

>> ["columnName1" "columnName2"]
ans = 
  1×2 string array
    "columnName1"    "columnName2"

Answer 1

[Cris LaPierre]

Use curly braces. From the doc page for sortrows

sortrows(tblA,{'Height','Weight'})

Use square brackets if you want to use indexing to specify the columns

sortrows(tblA,[1 4])

[Shana Hartel]

That worked. Thanks!

Answer 2

[madhan ravi]

Another possible solution:

sortrows(yourtable,[yourtable{:,1} yourtable{:,2}])