6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: There were more than 16 records in the source

Alteryx_KB
Alteryx
Alteryx
Created

Environment Details


  •  Alteryx Designer
    • All versions
  • Append Fields


Cause


The Append Fields tool creates a Cartesian Join (where every row from the Target input is joined to every row of the Source input) It is possible to unintentionally produce an excessive number of records, therefore it is recommended to keep the size of the Source input small. 



Resolution


If the inclusion of more than 16 records in the Source input is intentional, select another option in the Warn/ Error on Too Many Records Being Generated dropdown. 

  • Warn on appends of more than 16 records creates a warning instead of an error (second image)
  • Allow All Appends