Posts

Showing posts from 2020

How to Start or Stop Azure Firewall

Image
Cut your $1000 Azure Firewall monthly cost in Half using this Azure Firewall Operator Script.

Find the Row of a String from a Collection of Columns

Image
The formula works on Microsoft Excel for Mac version 16.36. Given: Problem: Kassandra is in which team? Formula: = INDEX ( RESULT_ARRAY , MATCH ( 1 , MMULT ( -- ( COLUMN_HAYSTACK = NEEDLE ), TRANSPOSE ( COLUMN ( COLUMN_HAYSTACK )^ 0 )), 0 )) Actual Application: = INDEX ( A3:A6 , MATCH ( 1 , MMULT ( -- ( B3:D6 = A7 ),  TRANSPOSE ( COLUMN ( B3:D6 )^ 0 )),0)) Result: "Eagle"

Terraform: Merge a List ofObjects into One

Image
The goal is to Merge a variable List of Objects from a Terraform Data Source   into One Object using Terraform's Merge function. mergedExpanded = merge(local.policy_parameters[*].parameters...) mergedHardcoded = merge(local.mergedExpanded[0].parameters,local.mergedExpanded[1].parameters,local.mergedExpanded[2].parameters)