Error message field "company code" is missing

[ckaufman921]

Hi, 

I keep getting this "company code" error on the summarize tool. Can anyone advise how to fix this?

Thank you! 

[suby]

Check your Input Source Data to see if the company code still exist.

[ckaufman921]

Yes, company code is in the input data.

[jdminton · Accepted solution]

It looks like the company code information is coming in from the right side of a join. Check inside the join and see if that field exists and if it is being renamed. If it is in there with the same name as the Summarize tool, I would try removing the field from the summarize tool and as it again.

[ckaufman921]

Thank you! I fixed the first error and now have this error, any thoughts?

[jdminton]

@ckaufman921 Please make the first issue as solved. The second is just telling you that the original named columns are no longer present with the same name. They may have changed names or been removed. It also could mean that you need to rerun it for the names to appear. Without the actual workflow or visuals for the tools in front of the error, it's hard to determine.

[jdminton · Accepted solution]

@ckaufman921 Looking back further in your workflow, it appears that you used the formula tool to rename the columns without the underscore character. You can either add the underscore in the formula (or remove the formula) or add them back in the select tool.