EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB441063: How to delete the first row when importing data through Data Import in MicroStrategy Web 10.x.


Community Admin

• Strategy


How to delete the first row when importing data through Data Import in MicroStrategy Web 10.x.

SUMMARY:
This technical note describes how to delete the first row when importing data through data import in Strategy Web 10.x.
CONTENT
When a user imports tables using Data import in Strategy Web, the user will like to remove the first row of data and use the second row as the top row.
 

ka04W000000ObjlQAC_0EM44000000WTe8.png


 
This can be done prior to wrangling the Cubes data, in the Data Import tables view mode, by going to the table's option --> Parse.
 

ka04W000000ObjlQAC_0EM44000000WTeD.png


  
The user then gets an interface with a clear "Skip ‘N’ rows from beginning" feature where you can specify how many rows you'd like to delete. 

ka04W000000ObjlQAC_0EM44000000WTeI.png

When the user applies the changes, the specified number of rows will be deleted from the table and the remaining rows will be moved up and used in the following order as a result. 

ka04W000000ObjlQAC_0EM44000000WTeS.png


KB441063


Comment

0 comments

Details

Knowledge Article

Published:

June 20, 2018

Last Updated:

December 24, 2018