Restore Invalid Column References Editor
Use this dialog box to restore the mappings of invalid column references. Column references can become invalid when you change the upstream component so that the column you mapped to is no longer available, or when you change the data type of a mapped column. You can set the restore option for invalid columns one by one, or apply one option to all invalid column references. The column references are grouped by input.
Options
- Invalid Input
Lists the inputs that are no longer valid.
- Invalid Column References
Lists the columns from the input that are not valid.
Available Columns
Select an available column in the list or a restore option in the list.Option Description <Leave as invalid column reference>
Leave the column references that are not valid. If you skip a column by using this option, the component remains in an invalid state.
<Delete invalid column references>
Delete the column references that are not valid.
- Include downstream invalid column references
Select to also restore downstream column references that are not valid.
- Select All
Click to select all the invalid column references.
Column mapping option for selected rows
Select a restore option in the list to apply to the selected column references.Option Description <Map using column name>
Map invalid column references to available columns using column names.
<Leave as invalid column reference>
Leave the column references that are not valid. If you skip a column by using this option, the component remains in an invalid state.
<Delete invalid column reference>
Delete the column references that are not valid.
- Apply
Click to apply the restore options to the selected column references.