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

Stefan Hering
Stefan Hering Employee
100 Up Votes Second Anniversary Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board
edited April 2023 in How-To Guides

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.

Datenquelle.PNG

Tagged:

Comments

  • Stefan Hering
    Stefan Hering Employee
    100 Up Votes Second Anniversary Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board
    Answer ✓

    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.

    Smart Import Object.PNG
    Mapping I.PNG
    Mapping II.PNG
    Mapping III.PNG

  • Federica Antonelli
    Federica Antonelli Employee
    Fourth Anniversary 25 Likes 10 Comments Level 200: Building A Planning Solution in Board

    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.

Categories