Overview

When you are creating models, there are common scenarios that occur. You can create bits of models, called  "patterns" to use in these scenarios.  You can then re-use the model patterns whenever the scenario occurs. Patterns can be:

• controls
• groups of controls
• portions of models.

A pattern is any solution that is useful and reusable, from very simple methods to more sophisticated model-fragments.

This topic contains pattern suggestions for some common modelling scenarios.

• Calculate an Average
• Load Data
  • Check Database Space Being Used
  • Load a Subset of Data from a Database
  • Load Binary Files
  • Load Data From the Web
  • Load From and Write to a Database
  • Manage Unsorted Data Using an In-Memory Stream
  • Speed Up Data Loading Using Parallel Collectors
• Compare or Match Data
  • Check Generated Files
  • Compare Two Files
  • Inexact Match for DateTimes
  • Inexact Match for Strings
  • Inexact Match Streams
  • Remove Duplicates
• Split or Combine Data
  • Break an SQL IN Clause Into Batches
  • Create Unique Indexes or Record Identifiers
  • Enrich Stream Data
  • Filter Values in a Lookup Pipe
  • Process Separate Files into Separate Streams
  • Reconcile Invoices
  • Turn One Record Into Multiple Records
  • Use a Master List