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