Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: The Header Field & Data Field cannot be the same field

Alteryx_KB
Alteryx
Alteryx
Created
 

Environment Details

 
  • Alteryx Designer
    • All versions
  • Cross Tab


Cause

 

The Cross Tab tool moves vertical data fields onto a horizontal axis and summarizes data. In this error, the same field ([Label] in the image below) was selected for both the new column headers and the new values. 



 

Resolution


The warning indicates that your new column headers and values for the new columns must be from two different columns. To resolve, select a new field for the column headers or for the column values. 



 

image.png

Additional Resources

No ratings