Handling Custom Columns in ETL Profile Updates

This article explains how to update ETL profiles with custom columns when the uploaded data file has a different number of columns.

 ACE prompts users about the impact on custom columns.

Prompt to Update Columns:

a. If the prompt appears, review the changes in the uploaded data file and determine if the custom columns need to be adjusted.

b. If necessary, select "yes" to update the columns to match the new file.

Locate the Data Map Section:

a. After selecting "yes," navigate to the data map section of the ETL profile.

b. Identify any new columns of data in the uploaded file that needs to be mapped.

c. Select the appropriate mapping field in the data map section for the new column.

Apply/Save Changes:

a. Click Save or Apply