Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In this exercise you will add an Output Filter output filter to the Stream stream 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:

  • Open the configuration form for the Stream stream Channel List Reconciliation 2Go to the Advanced tab
  • In the Output Filter enter the value:
Code Block
_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)

  • Save your changes to the stream
  • Run analysis on Channel List Reconciliation 2
  • Check that the Stream stream now only contains records that could not be reconciled between the two sources