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.