The Ensure Fields Tool ensures a set of fields are present in a datastream. This is a common issue when you are reading data that changes from time to time. If you use a Crosstab Tool or are reading from an XML file, the output fields can change based on the presence (or absence) of specific input data. This makes it very hard to write formulas, or really do any down stream processing on those fields. In particular, what we want to do is ensure fields are present, but NOT change them if they are already in the record. The macro originally appeared on http://inspiringingenuity.net/2013/08/14/alteryx-ensuring-fields-are-in-a-data-stream/
The tool has two configuration properties:
___________________________________________________________________________________