Enrolment options

Generating Missing Data

Auto Enrol

This module will explore scripting techniques to generate missing data.

Learning Objectives:

  • Propagate values from the previous record using Peek()
  • Generate records to fill gaps with IterNo() in a WHILE loop
  • Accumulate transactions to create a balance field
  • Split a delimited list of values into multiple records using SubField()
  • Generate Cartesian product
  • Inspect Monte Carlo simulations: two thrown dice and initial poker hand
  • Replace nulls using IsNull() and NullAsValue

Content last reviewed and updated on 1-Feb-2022

You don’t have access to this course. Click the Continue button below to login or click the browser's back button to return to the previous page.