{"id":1212,"date":"2016-12-28T18:30:07","date_gmt":"2016-12-28T13:00:07","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1212"},"modified":"2016-12-28T18:30:07","modified_gmt":"2016-12-28T13:00:07","slug":"msbi-error-while-skipping-data-rows","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1212","title":{"rendered":"MSBI Error while skipping data rows"},"content":{"rendered":"<p>In yesterday\u2019s <a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI training class in Mumbai<\/a> one of our students got the following error \u201cSkipping data rows\u201d as shown in the below figure.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7.jpg\" rel=\"attachment wp-att-1213\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1213\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7.jpg\" alt=\"1\" width=\"627\" height=\"229\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7-300x110.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>The error itself was not explanatory but when we debugged further we found it was because of uneven number of columns in source and destination files.<\/p>\n<p>Actually we had two CSV files as shown in the below figure. The first CSV files is proper and the second CSV file has missing columns (Country, state, product and sales person).<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-6.jpg\" rel=\"attachment wp-att-1214\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1214\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-6.jpg\" alt=\"2\" width=\"627\" height=\"269\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-6.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-6-300x129.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-6.jpg\" rel=\"attachment wp-att-1215\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1215\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-6.jpg\" alt=\"3\" width=\"628\" height=\"253\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-6.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-6-300x121.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>The second file was the culprit. Once we fixed the second files with proper columns everything ran smoothly.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-5.jpg\" rel=\"attachment wp-att-1216\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1216\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-5.jpg\" alt=\"4\" width=\"628\" height=\"287\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-5.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-5-300x137.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-4.jpg\" rel=\"attachment wp-att-1217\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1217\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-4.jpg\" alt=\"5\" width=\"529\" height=\"244\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-4.jpg 529w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-4-300x138.jpg 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6-2.jpg\" rel=\"attachment wp-att-1218\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1218\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6-2.jpg\" alt=\"6\" width=\"538\" height=\"188\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6-2.jpg 538w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6-2-300x105.jpg 300w\" sizes=\"(max-width: 538px) 100vw, 538px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7-2.jpg\" rel=\"attachment wp-att-1219\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1219\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7-2.jpg\" alt=\"7\" width=\"628\" height=\"375\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7-2.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7-2-300x179.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>We thank all our students who have attended our current <a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI classes in Andheri Mumbai<\/a> this week and we wish the best of luck for their future success.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In yesterday\u2019s MSBI training class in Mumbai one of our students got the following error \u201cSkipping data rows\u201d as shown in the below figure. The error itself was not explanatory but when we debugged further we found it was because &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1212\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[106],"tags":[121,131,124,132,109,108,120],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MSBI Error while skipping data rows - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stepbystepschools.net\/?p=1212\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MSBI Error while skipping data rows - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"In yesterday\u2019s MSBI training class in Mumbai one of our students got the following error \u201cSkipping data rows\u201d as shown in the below figure. The error itself was not explanatory but when we debugged further we found it was because &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1212\" \/>\n<meta property=\"og:site_name\" content=\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-28T13:00:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"StepByStepSchoolsSupport\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\",\"url\":\"https:\/\/www.stepbystepschools.net\/\",\"name\":\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"description\":\"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stepbystepschools.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1212#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1212#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1212\",\"name\":\"MSBI Error while skipping data rows - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1212#primaryimage\"},\"datePublished\":\"2016-12-28T13:00:07+00:00\",\"dateModified\":\"2016-12-28T13:00:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1212#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1212\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1212#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MSBI Error while skipping data rows\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\",\"name\":\"StepByStepSchoolsSupport\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"caption\":\"StepByStepSchoolsSupport\"},\"url\":\"https:\/\/www.stepbystepschools.net\/?author=40\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MSBI Error while skipping data rows - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stepbystepschools.net\/?p=1212","og_locale":"en_US","og_type":"article","og_title":"MSBI Error while skipping data rows - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"In yesterday\u2019s MSBI training class in Mumbai one of our students got the following error \u201cSkipping data rows\u201d as shown in the below figure. The error itself was not explanatory but when we debugged further we found it was because &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1212","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2016-12-28T13:00:07+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"StepByStepSchoolsSupport","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.stepbystepschools.net\/#website","url":"https:\/\/www.stepbystepschools.net\/","name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","description":"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stepbystepschools.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/?p=1212#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-7.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1212#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1212","name":"MSBI Error while skipping data rows - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1212#primaryimage"},"datePublished":"2016-12-28T13:00:07+00:00","dateModified":"2016-12-28T13:00:07+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1212#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1212"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1212#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"MSBI Error while skipping data rows"}]},{"@type":"Person","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655","name":"StepByStepSchoolsSupport","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","caption":"StepByStepSchoolsSupport"},"url":"https:\/\/www.stepbystepschools.net\/?author=40"}]}},"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1212"}],"collection":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1212"}],"version-history":[{"count":1,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1212\/revisions"}],"predecessor-version":[{"id":1220,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1212\/revisions\/1220"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}