Special editing options for table fields

The software supports the following special table field editing options:

• For table fields that have a 2D or 3D spatial independent domain and a single-variable dependent domain, you can define the coordinates for a tabular data point by selecting the point in the graphics window. After you select the point, in the Points in Table dialog box, in the Value box, you can type the corresponding value for the dependent variable.

• You can define and edit tabular data in an Excel spreadsheet.

• You can numerically offset the tabular data for the variables that comprise the independent domain of a table field.When you use this capability, you can specify an offset value for each variable in the independent domain. The software replaces each tabular value with the sum of the tabular value and the corresponding offset value.For example, suppose that the independent domain of a table field is Cartesian coordinates, and a tabular value for an x-coordinate is 4.5. If you specify the offset for the x-coordinate to be -2.3, the software replaces 4.5 with 2.2.

• You can swap columns of tabular data in a table field from one variable to another.

• You can edit the independent and dependent domain types of table fields.When you edit the independent or dependent domain of a table field and the new and old domains contain the same number of variables, the software assigns the data for the first variable in the old domain to the first variable in the new domain, the second variable in the old domain to the second variable in the new domain, and so on.For example, suppose you edit a table field that has a Cartesian independent domain and you change the independent domain to cylindrical. The software assigns the data for the x-coordinate of the Cartesian system to the radial coordinate of the cylindrical system, the data for the y-coordinate of the Cartesian system to the tangential coordinate of the cylindrical system, and so on.When you edit the independent or dependent domain of a table field and the a new domain does not have the same number of variables as the old domain, you use the options in the Data Rearrange dialog box to specify how the software rearranges the tabular data.For more information on these options, see Data Rearranging Options.

• For table fields imported from an external file or created from a formula field, you can open the external file or formula field directly from the Table Field dialog box. To update the tabular data to reflect the changes that you made, you can reload the tabular data for the table field directly from the Table Field dialog box.

Data Rearranging Options

When you edit the independent or dependent domain of a table field and the new and old domains do not have the same number of variables, you use the options in the Data Rearrange dialog box to specify how the software rearranges the tabular data. How the two options work is best described through examples.

Suppose that for the following table field you want to change the independent domain from Cartesian to node ID.

x	y	z	Pressure
0	1.2	-4	200
6.3	2	0	55.3
4.1	0	2.8	78.9
-3	0.5	-1.6	50

If you click Reflow, the software rearranges the tabular data into the following form:

Node ID	Pressure
0	1.2
-4	200
6.3	2
0	55.3
4.1	0
2.8	78.9
-3	0.5
-1.6	50

If you click Keep Data in Original Column, the software rearranges the tabular data into the following form:

Node ID	Pressure
0	200
6.3	55.3
4.1	78.9
-3	50

In the previous example, there are fewer variables in the new independent domain than the old independent domain. In the next example, there are more.

Suppose that for the following table field you want to change the dependent domain from force to force components.

Node ID	Force
1	25.3
2	-18
3	20
4	46.8
5	0
6	-24.5

If you click Reflow, the software rearranges the tabular data into the following form:

Node ID	Force_1	Force_2	Force_3
1	25.3	2	-18
3	20	4	46.8
5	0	6	-24.5

If you click Keep Data in Original Column, the software rearranges the tabular data into the following form:

Node ID	Force_1	Force_2	Force_3
1	25.3	0	0
2	-18	0	0
3	20	0	0
4	46.8	0	0
5	0	0	0
6	-24.5	0	0

Where do I find it?

Defining the coordinates of tabular data by picking points in the graphics window

Application	Pre/Post
Prerequisites	The Table Field dialog box is open
Location in dialog box	Table Field dialog box→Select Data Point Location

Defining and editing tabular data in a spreadsheet

Application	Pre/Post
Prerequisites	The Table Field dialog box is open
Location in dialog box	Table Field dialog box→Edit table in spreadsheet

Offsetting the tabular data of a table field

Application	Pre/Post
Prerequisites	A table field is listed in the Simulation Navigator under the Fields node
Simulation Navigator	Expand the Fields node→Right-click the table field and choose Edit
Location in dialog box	Table Field dialog box→Offset Variable Data

Swapping the tabular data of a table field

Application	Pre/Post
Prerequisites	A table field is listed in the Simulation Navigator under the Fields node
Simulation Navigator	Expand the Fields node→Right-click the table field and choose Edit
Location in dialog box	Table Field dialog box→Swap Variable Data

Editing the domains of a table field

Application	Pre/Post
Prerequisites	A table field is listed in the Simulation Navigator under the Fields node
Simulation Navigator	Expand the Fields node→Right-click the table field and choose Edit
Location in dialog box	Table Field dialog box→Domain group

Editing the external file from which the table field was imported and reloading the tabular data

Application	Pre/Post
Prerequisites	The Table Field dialog box open for a table field that was imported from an external file
Location in dialog box	External Data Source group→Edit Data Source and Refresh from Data Source

Editing the formula field from which the table field was created and refreshing the tabular data to reflect the changes to the formula field

Application	Pre/Post
Prerequisites	The Table Field dialog box open for a table field that was created from a formula field
Location in dialog box	Data Source group→Edit Data Source and Refresh from Data Source

How do I

Create a table field

Create a table field from results

Create a table field from a formula field

Create a table field from an AFU file

Define a boundary condition using a table field

Define a material property using a table field

Define a table field with complex dependent variables

Learn more

Table fields

Creating table fields from results

Defining tabular data

Defining pressure and power data in dB

Duplicate data

Removing sliver triangles

Importing ordered or structured tabular data from a text file

Controlling the display of error messages

Mesh size fields

Look up more details

Table field interpolation and extrapolation options

Lookup options for fields created from results

Quick links

Command reference

Pre/Post video examples

Bulk Entry Descriptions

Simcenter 3D tutorials

Browse Simcenter 3D help by product area

Special editing options for table fields, Simcenter 3D 2021.1 Series

© 2020 Siemens

window.mainLanguage="en_US"

window.delivId=""

window.projectId=""

MathJax.Hub.Config({ TeX: { extensions: ["autoload-all.js"] }, tex2jax: { displayMath: [ ] }, "SVG": { scale: 125 } });