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()
- Use table join to generate Cartesian product
- Monte Carlo simulations: Two thrown dice and initial poker hand
- Explain functions used in Qlik’s Sample Data Script
- Replace nulls using IsNull() and NullAsValue