To filter data during import

When you import data into your model, you can filter the data you bring into the model and only map the desired properties of original data source(s) to supported properties in the model.

  1. Click to open the Data Sources panel and add your data source(s).
  2. Double-click the desired data source to configure it.
  3. In the Data Source Configuration window, click the Source tab or the Table tab.
    • Source tab: In the Source Filter field, click to open the Expression Editor.
    • Table tab: Click in the desired model property field .
  4. Create the desired expression.
    Note: The properties available in the Source Filter dialog box are the properties of the original data.

    For help with any expression element, see Creating Expressions - Reference.

  5. Click OK.
  6. Complete any other configuration settings, then click OK & Refresh.

For more information on importing data, see To import data.