Main Content

Fill a Single Lookup Table

You can fill a single lookup table using one of these workflows:

Fill a Lookup Table From Measured Data

Follow these steps to fill a single lookup table from measured data:

  1. Open the Lookup Table Fill Wizard.

    • With the table selected in the Lookup Tables view, select Table > Fill.

    • Alternatively, click the Fill toolbar button .

    The Lookup Table Fill Wizard opens.

    Lookup table fill wizard for SA_Table.

  2. From the Input data list, select a data set.

    Click Setup to create a constraint. Constraints filter rows from the input data to restrict the values that CAGE uses to fill the feature.

    Input data source options.

  3. Set the right drop-down list of Filled by to Data and the left drop-down list to the data set column to use to fill the table.

    Filled by options to set SA_Data and Data.

  4. You must set the Smoothing factor to a nonzero value to fill a table from a data set. Smoothing performs an extrapolation for cells in the lookup table data where data is not available. Click Finish.

    Optionally, you can turn off smoothing or force the lookup table to be linear for a given direction. From the drop-down lists under Row (Y) or Column (X), select linear or off.

    Smoothing options in the Lookup table fill wizard.

    Alternatively, on the Lookup Tables view, use the Smoothing factor to interactively change the smoothing factor after you fill a lookup table.

    Lookup table surface.

  5. In the Lookup Table view, the black dots represent the filling data. Evaluate the fit of the black dots on the lookup table surface. For more detailed plots of the data fit, navigate to the right side of the Lookup Table view and double-click the feature under Used in to open the Feature view.

    Used in view

    In the Feature view, go to the Validation tab. From Plot types, select plots to evaluate the fit.

    Validation tab in feature view.

Note

Filling a table from a data set produces similar results to using the fitlookupn function.

Fill a Lookup Table from a Model

Follow these steps to fill a single lookup table from a model evaluated at the table breakpoints:

  1. Open the Lookup Table Fill Wizard.

    • With the table selected in the Lookup Tables view, select Table > Fill.

    • Alternatively, click the Fill toolbar button .

    The Lookup Table Fill Wizard opens.

    Lookup table fill wizard for SA_Table.

  2. From the Filled by list, select the model that you want to fill the table with.

    Filled by selection dialog box.

  3. Set Input data to Grid.

    Click Setup to create a constraint. Constraints filter rows from the input data to restrict the values that CAGE uses to fill the feature. By default, the toolbox sets Constraint to the boundary model associated with the main model to use the data points within the boundary. You can also define a function model to use as a constraint.

    Click Next.

    Input data source options.

  4. Connect model and feature inputs. Use results from lookup tables as inputs by connecting tables to inputs. Connect variables that describe the same quantities. Click Next.

    Connect Inputs view in the Lookup table fill wizard.

  5. If you do not connect the model and feature inputs prior to clicking Next, the input grid values are set to an average fit over all values.

    Look up table fill wizard input grid values when model and feature inputs are not connected.

    If you connect the model and feature inputs, the input grid values are set to the breakpoints of the table values. Click Finish.

    Lookup table fill wizard input grid values when model and feature inputs are connected.

  6. In the Lookup Table view, the black dots represent the filling data. Evaluate the fit of the block dots on the lookup table surface.

    Lookup table surface

    For more detailed plots of the data fit, navigate to the right side of the Lookup Table view and double-click the feature under Used in to open the Feature view.

    Used in view

    In the Feature view, go to the Validation tab. From Plot types, select plots to evaluate the fit.

    Validation tab in feature view.

See Also

Topics