How to hide/ignore columns of an Excel data source when using the Smart Import Object

Stefan Hering · 2023-03-31T12:43:37+00:00

There was an error rendering this rich post.

Is it possible to hide/ignore columns of an Excel data source if they are not relevant for the import when using the file upload of the Smart Import Object (e.g. descriptions or comments)?

In the following table, columns A,B (entities) and D,E (values) have to be imported, columns C,F have to be ignored.

Find more posts tagged with

Data Loading Strategies

Data Sources

Data Reader

Comments

Stefan Hering

After selecting the relevant cubes and entities in the left column of the mapping, the columns that are not relevant can be moved to the end of the mapping. Thus, they are not considered for the import and do not have to be deleted from the data source in advance.

Federica Antonelli

Nice Tip @Stefan Hering! The Smart Import allows to have fields in the source file that are not mapped with anything in the datamodel - these will be then ignored.

I suggest to move this post to the How-to section @Holly Rieke.