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.