Arrange loaded data

This group contains operations that can be performed on the table as a whole.

Transpose

Rotate the table so that each row becomes a column.

This is useful when the input table format is column-oriented (each data sample written on a new column), since Simcenter Amesim expects row-oriented table formats (each data sample written on a new row).

For example, the following table:

... looks like this after transposition:

Remove empty rows

This command allows you to remove from the table all rows that contain no data.

This is useful if the input file contains many empty rows that are otherwise tedious to remove individually.

Sort columns

Use the Sort button to change the order of rows, such that all values on a column become ascending or descending.

Note

To use the Increasing/Decreasing sort feature, you must first select a column, specify the sort order, and then click the Column sort button.

The Advanced sort Advanced sort option opens a dialog box in which you can define the sort order sequentially, column by column.

You can use the Add another sort column button to add available columns to the list and define the sort order (ascending or descending) for each.