Generic field mapping (table mapping) uses matrix columns (source data) to map and export target elements to a new Excel table.
Supported field mapping entities include: Temperature, Displacement, Pressure, and Property Id. These entities are standard Engineering Solutions data base entries. Entries which are not standard Engineering Solutions supported field entities can be mapped using the Matrix browser and a table entity.
1. | Open the model containing source data. |
2. | Create and define a field entity. |
a. | In the Model browser, right-click and select Create > Field from the context menu. |
b. | In the Entity Editor, set Type to continuous, System type to real, and Source to matrix. |
c. | Right-click on the Source field and select invoke from the context menu. |

3. | In the Field dialog, select source data to map. |
a. | From the DataSource list, select HMdata. |
b. | From the Entities list, select elements or nodes. |
d. | In the panel area, use the elems/nodes selector to select elements/nodes, then click proceed. |
e. | In the matrix, click the elements column. |
f. | From the Datanames list, select the type of data to import and then click Query. |
A table entity, containing all of the mapping entities based on the source model, is automatically created.

4. | Delete the source model. |
a. | In the Model browser, right-click on the field and select Realize from the context menu. |
b. | In the Field Realization dialog, define realization settings. |
• | Set the Field type to table. |
• | Select the table created by the matrix browser. |
• | Set the Field column to the column name used in the Matrix browser. |
A new table entity is created based on the target element/nodes after mapping (field realization).

6. | Export target elements to Excel. |
a. | Invoke the Matrix browser from the menubar by clicking Tools > Matrix browser. |
b. | Set Worksheet to the new table created during mapping. |

See Also:
Fields