/
9 Filtering Table Output

9 Filtering Table Output

Owned by Chris Welford
Last updated: Jul 07, 2023 by Zoe Baldwin


By the end of this chapter you will be able to:

  • Filter data written to tables using Output Filters

In this exercise you will add an output filter to the table you created in the previous exercise, to keep only records which show an error in the reconciliation between the inventory database and the channel list in your model:

  1. Open the Properties for the table Channel List Reconciliation 2
  2. Under Analysis Options is the expression field Select Records for Output - enter the value:
_out.SalesCheck == "NO" || _out.InvCheck == "NO"

(In the expression above, the operator || means "or" – so the whole expression is true if either the value in SalesCheck or InvCheck is NO)

3. Save your changes to the table.

4. Run analysis on Channel List Reconciliation 2

5. Check that the table now only contains records that could not be reconciled between the two sources.

6. In the model window, click  Save.