cancel
Showing results for 
Search instead for 
Did you mean: 

Do Not Fail if Columns Change

Highlighted
NiCd Battery
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
2 Replies
Highlighted
NiCd Battery
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
Highlighted
Blue LED
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