Generic Field Mapping

Generic field mapping (table mapping) uses matrix columns (source data) to map and export target elements to a new Excel table.

1. Open the model containing the source data.
2. Create and define a field entity:
   1. In the Model Browser, right-click and select Create > Field from the menu.
   2. In the Entity Editor, set Type to continuous, System Type to real, and Source to matrix.
   3. Right-click on the Source field and select Invoke from the menu.
3. In the Field dialog, select the source data to map.

   
   
   Figure 1.

   1. From the DataSource list, select HMdata.
   2. From the Entities list, select elements or nodes.
   3. Click the Query button.
   4. In the panel area, use the elems/nodes selector to select elements/nodes and then click Proceed.
   5. In the matrix, click the Elements column.
   6. From the Datanames list, select the type of data to import and then click the Query button.
   7. Click OK.
      A table entity containing all of the mapping entities based on the source model is automatically created.
4. Delete the source model.
5. Realize the field:

   
   
   Figure 2.

   1. In the Model Browser, right-click on the field and select Realize from the menu.
   2. Set Field Type to table.
   3. Select the table created by the Matrix Browser.
   4. Set Field Column to the column name used in the Matrix Browser.
   5. Click Apply.
   A new table entity is created based on the target element/nodes after mapping (field realization).
6. Export target elements to Excel:
   1. Open the Matrix browser from the menu bar by clicking Tools > Matrix Browser.
   2. Set Worksheet to the new table created during mapping.
   3. Click Excel.

      
      
      Figure 3.