3.14.6 New Field or Update Existing?

For most situations, determining how to handle a column is relatively simple.

New Name

If there is no field with the same name as the column, a new field is created. The source tables are recorded against the field for future reference.

These fields will have a status of New.

Existing Name

If there is a field with the same name as the column, the source of the field (that is, the tables from which it is derived) are compared to the tables being loaded. If the tables match, the field is updated with the column attributes.

These fields will have a status of Changed.

Existing Name and Partial Reload

When a name match is found and the column attributes have changed, the source tables are assessed. If they are not the same, the Transformation process cannot determine what to do. The field is being used in multiple LANSA tables, but not all source table information is available.

...

A drop-down is provided so that you can determine whether the field should be updated, a new field created, or the change ignored.

Existing Name and Mismatch

When loading multiple tables, it is possible that the same column name has different attributes from each source table and these may not match the LANSA field. Once this scenario is encountered, the transformation Process can only resolve to create a new field.

...

It is strongly recommended that the source tables and columns be investigated to determine the cause of the mismatch.

Finish

Once the Finish button is clicked, the fields and tables will be created.

...