Use the SKIP keyword in Member Mappings

In certain cases, the file you are importing may contain rows that you wish to skip during an import. 

For example, the source data file may contain several rows with a Cost Center named Default and you need to skip these rows during the data import. You can use the SKIP keyword to achieve this.

To skip a row for a specific source member:

1. Create a new Member Map for the dimension.
2. Add the member mappings.
3. Enter the source name in the Source Value column to skip rows with specific members.
4. Use the <SKIP> keyword in the Mapped Value column.
   In this example, any rows with Default as the Cost Center in the import file will be skipped as the data is imported from the staging table to the data model in the system.

5. Save the changes.
6. Refer to this Member Map in the appropriate Dimension Field Settings when configuring the corresponding Data Import Definition.

To skip a row with a blank member:

1. Create a new Member Map for the dimension that may contain blank members.
2. Add the member mappings.
3. Use the <BLANK> keyword in the Source Value column to skip blank members. 
4. Use the SKIP keyword in the Mapped Value column.
   In this example, any rows with blank Cost Centers in the import file will be skipped as the data is imported from the staging table to the data model in the system.

5. Save the changes.
6. Refer to this Member Map in the appropriate Dimension Field Settings when configuring the corresponding Data Import Definition.

You can use the filter option in the View Source Details pane of Data Import Logs to view records that were skipped during the import. This may be helpful when troubleshooting as it provides an easy way to view records that were skipped.

To view skipped records in the import logs:

1. Navigate to the Logs module.
2. Locate the row that corresponds with your data import in the Data Imports tab.
3. Right-click the ellipsis in the Details column and select View Source Details.
4. Use the dropdown list to select Show Skipped Records to view any records that were skipped during the data import.