Table Of Contents
Table Of Contents

2023-05-22 - Rule Templates for Given Tiles Iteration

Problem

Creating rules which use a shared tile for the Given doesn’t always work because of missing expected columns like effective date, or row key etc.

Solution

Use a simple fall back pattern … if effective_date is in the Given tile then use it, if not check for user effective date rule and use that, else fall back to current_date() as the effective date.

Check for expiry_date in the Given tile, same pattern as above.

Do the same for consume tiles which are used for the Given.

Leverage the Magic

A magical feature, no action by Data Magicians required.

ADI

Woohoo!, love it when we reuse patterns to provide more simplciity for the Data Magician.

Customer

Yippee!, now I can use any tile as a Given tile in a rule.