🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

How do I delete an External Lookup in Monarch Classic 14 when the Data Source no longer exists?

Altair Forum User

When going to Table Design, Monarch presents the error message: "Fields in External Lookup ___ did not match schema."

This is fine, and expected, because the Excel file referenced by that External Lookup no longer exists, but when going in to External Lookups, and selecting that data source, the "Delete" button become inactive. The only buttons active are "Cancel" and "Change Data Source," but I do not want to change the data source, I want to delete the data source. How can I do that?

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Altair Forum User

It looks like your model is corrupted. I suggest you select change data source and select the same file or different file, and then see if the Delete button becomes enable.

Altair Forum User

It looks like your model is corrupted. I suggest you select change data source and select the same file or different file, and then see if the Delete button becomes enable.
Mo

The original file no longer exists, so that is not an option.

We did change the data source to some other Excel file, but immediately received the error again: "Fields in External Lookup ___ did not match schema." And the Delete button remains inactive.

Everything else in the Model works fine.

Altair Forum User

I can confirm that I did what Mo suggested in a prior model and it worked for me. I just changed the data source to some other file that had no relation, and gave it a link between records i knew had no relation, but in the end it would allow me to delete the lookup once I changed the data source.

I am running the latest version 14.2