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

Not logged in? or you may not have access to this course. Click the Continue button to login or click the browser's back button to return to the previous page.