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

Altair Forum User
Altair Forum User
Altair Employee
edited July 2017 in Community Q&A

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?

External Lookup error.png

Tagged:

Answers

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited July 2017

    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

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited July 2017

    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
    Altair Forum User
    Altair Employee
    edited July 2017

    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