topic Re: Can not create/calculate field as it may contain a deleted data column. in Data & Schema Discussions

Can not create/calculate field as it may contain a deleted data column.

Won2RoolThemAll — Tue, 24 May 2022 00:58:50 GMT

I am trying to use a lookup function in a formula field and I get this message:

"Can not create/calculate field [schema table and field name here ] as it may contain a deleted data column."

The details don't provide any additional value.

The columns I am trying to reference are present and loaded. Any ideas what this means?

Re: Can not create/calculate field as it may contain a deleted data column.

dylanwan — Tue, 24 May 2022 01:07:54 GMT

Does it work for other columns or other lookup tables? Can you try to review the data by creating an another insight on the lookup table?

Re: Can not create/calculate field as it may contain a deleted data column.

Won2RoolThemAll — Tue, 24 May 2022 01:42:10 GMT

Thanks for the reply Dylan. Not sure what happened, but I removed the formula column, saved the schema and then started over. This time after saving the formula column with the lookup, it did not complain and worked as expected. Hmm.