ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: The field “[field_name]” is missing. Compare the tool configuration with the input stream


Environment Details

Note: In versions prior to 2021.1.4, this error message text is "The field "[field_name]" is not contained in the record."
  • Alteryx Designer
    • All versions
  • Impacted Tools
    • Arrange
    • Create Points
    • Cross Tab
    • DateTime
    • Distance
    • Download
    • Dynamic Input
    • Dynamic Replace
    • Email
    • Filter
    • Find Nearest
    • Find Replace
    • Fuzzy Match
    • Generate Rows
    • Interactive Chart
    • JSON Parse
    • Join
    • Join Multiple
    • Layout
    • Multi-Row Formula
    • Output Data
    • Poly Build
    • RegEx
    • Render
    • Running Total
    • Sample
    • Sort
    • Spatial Info
    • Spatial Match
    • Spatial Process
    • Summarize
    • Summarize In-DB
    • Table
    • Text To Columns
    • Tile
    • Trade Area
    • Unique
    • User Macros
    • XML Parse


Something changed in the metadata, and the field/ column is no longer available. Perhaps the name was changed upstream or deselected in an intermediate tool. For example, if the Summarize tool returns this message, it means that the column it was expecting to summarize is no longer in the data stream (and is followed by the {Action} that the Summarize tool was performing).


Compare the tool configuration with the input stream. Trace backwards from the erroring tool to find out where the column went “missing.” See Cross Tab image below.

5 - Atom

Hello, I am getting this error when running my macro, but do not see the field in a select tool. Do you have any suggestions?


You should open up your macro and see what field names you have throughout.  If you need assistance and you hold a paid license, you can open a case with Customer Support to help you.  They will need for you to provide your macro and possibly some sample data as well.