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