How to hide/ignore columns of an Excel data source when using the Smart Import Object
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.
Comments
-
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.
3 -
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.
0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 158 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 335 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP