cancel
Showing results for 
Search instead for 
Did you mean: 

Do Not Fail if Columns Change

Do Not Fail if Columns Change

What does the "Do Not Fail if Columns Change" option do in the automation screen? Does it ignore row heading changes, missing columns, columns that have moved positions, etc.?
Labels (1)
0 Kudos
1 Solution

Accepted Solutions

If you check this new option then the automated run of the project will not fail if the latest version of a dataset has a different layout.  For example: new columns added, removed columns that are not used in the Project's Steps, different column types for existing columns, a new column order, etc. As long as the columns used in the Project's Steps are available in the latest version of the dataset, then the automated run will succeed with this option selected.

View solution in original post

0 Kudos
2 Replies

If you check this new option then the automated run of the project will not fail if the latest version of a dataset has a different layout.  For example: new columns added, removed columns that are not used in the Project's Steps, different column types for existing columns, a new column order, etc. As long as the columns used in the Project's Steps are available in the latest version of the dataset, then the automated run will succeed with this option selected.
0 Kudos

In addition to all that @marthamiller_SE mentioned, if your Project defines transformations based on column criteria (example, 'trim leading and trailing white spaces on all columns of type Text', the transformation will be extended to new columns that satisfy the selection criteria (In the example cited here, any new Text column that is run through the automation will be trimmed of leading and trailing white spaces) 
0 Kudos