About the Ensure Fields Tool:

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/

Configuration Properties:

The tool has two configuration properties:

  • Specify a list of fields
  • Select the type for new fields
  • Version History:

  • Version 1.0 - As featured on http://inspiringingenuity.net.
  • Version 2.0 - Adopted by CRW. Updated to CRW styling.
  •  

     

    ___________________________________________________________________________________

    www.ChaosReignsWithin.com