{"id":38717,"date":"2018-11-13T17:51:38","date_gmt":"2018-11-13T12:21:38","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38717"},"modified":"2021-12-07T11:20:20","modified_gmt":"2021-12-07T05:50:20","slug":"qlikview-transformation-wizard","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/","title":{"rendered":"QlikView Transformation Wizard\u00a0&#8211; How to Delete Rows in QlikView"},"content":{"rendered":"<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">In this section of the tutorial, we will learn about what is\u00a0QlikView transformation wizard and its functions. Moreover, we will learn how to use\u00a0transformation wizard\u00a0and\u00a0<\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">deletion or Garbage tab of the <strong>transformation wizard in QlikView<\/strong>.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Data transformation is the process of transforming or modifying data after loading it in QlikView\u2019s memory.<\/span><\/span><\/p>\n<p align=\"justify\">So, let&#8217;s start QlikView T<span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">ransformation Wizard Tutorial.<\/span><\/span><\/p>\n<div id=\"attachment_38828\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38828\" class=\"size-full wp-image-38828\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01.jpg\" alt=\"QlikView Transformation Wizard\u00a0- How to Delete Rows in QlikView\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-38828\" class=\"wp-caption-text\">QlikView Transformation Wizard\u00a0&#8211; How to Delete Rows in QlikView<\/p><\/div>\n<h3 align=\"justify\">QlikView Transformation Wizard<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The QlikView Transformation Wizard use for modify data after loading it into QlikView\u2019s memory from an external source. This is the Transformation step from the ETL (Extract, Transform, Load) process. You can perform certain data modification or alteration functions like deletion (Garbage), addition or fill, column, unwrap, rotate etc.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-time-chart-wizard\/\">Do you know what is QlikView Time Chart Wizard?<\/a><\/strong><\/p>\n<h3 align=\"justify\">Functions of Transformation Wizard in QlikView<\/h3>\n<p>These are QlikView Transformation Wizard\u00a0Functions:<\/p>\n<h4 align=\"justify\">i. Garbage<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The Garbage tab removes or deletes the unwanted rows and columns from the table. It often happens in the case of HTML documents that they have extra rows and columns which are not of use. The garbage tab has two options, <\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Delete Marked<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">, which deletes the highlighted rows and columns. <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Conditional Delete\u2026<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> which deletes the rows based on a conditional criterion. <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<h4 align=\"justify\">ii. Fill<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Using the Fill tab, you can fill empty cells or replace the cell values with new values from the same column. It is used when you want to fill the same value from the column in other cells of that column. This can be done using <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Fill..<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> button given in the fill tab, where you can specify fill conditions and strategize filling of cells. <\/span><\/span><\/p>\n<h4 align=\"justify\">iii. Column<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Through the Column tab, you can copy or duplicate the contents of one column to a new column. You can either copy all the cells of a column to a new one or select set of cells. There are two options given in this tab,<\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>New\u2026<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option opens a dialog called Specify cells for new column where you can specify the copy details about the column\u2019s cells. <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The<\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b> Label <\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">option lets you set the label or name of the new column. <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<h4 align=\"justify\">iv. Unwrap<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">From the Unwrap tab, you can unwrap a wrapped table. By a wrapped table it is meant that one half of the table comes on the right of the first half of table contents. The options available in Unwrap column lets you regain the normal\/unwrapped (second half below first half) state. There are two options in the Unwrap tab,<\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">From the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Unwrap<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option the table is unwrapped. A table can wrap vertically or horizontally, so setting the border between the two is important.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">From the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Conditional Unwrap<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option, you can specify a condition for unwrapping the table. <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<h4 align=\"justify\">v. Rotate<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The Rotate tab changes the orientation of a table. The rows and columns switch places. This is a very popular layout, which is mostly use by web designers. You can rotate a table in three ways from the rotate tab. <\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Left<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option rotates the table counterclockwise<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Right<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option rotates the table clockwise<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Transpose<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option transposes a table, also calls mirroring a table along the diagonal axis. It switches the places of cells on top right corner and bottom left corner.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/\">Let&#8217;s Explore Left, Right, Inner Keep Function in QlikView<\/a><\/strong><\/p>\n<h3>How to Delete Row using Transformation Wizard?<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Let us learn how to delete some rows from our existing data set using QlikView Transformation Wizard.<\/span><\/span><\/p>\n<h4>i. Load Data<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Open a new QlikView document. Open the scrip editor using the icon on the toolbar or by CTRL+E. Then go to the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Insert<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option and select <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Load Statement<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">. After this select <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Load From File<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option.<\/span><\/span><\/p>\n<div id=\"attachment_38813\" style=\"width: 655px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38813\" class=\"size-full wp-image-38813\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans1.png\" alt=\"How to Delete Rows using QlikView Transformation Wizard\" width=\"645\" height=\"707\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans1.png 645w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans1-137x150.png 137w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans1-274x300.png 274w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans1-520x570.png 520w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/><\/a><p id=\"caption-attachment-38813\" class=\"wp-caption-text\">How to Delete Rows using QlikView Transformation Wizard &#8211;\u00a0Load Data<\/p><\/div>\n<h4 align=\"justify\">ii. Selecting From Source<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Now, you will direct to the storage drives in your devices from which you can select any CSV file. Click on <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Open<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">.\u00a0<\/span><\/span><\/p>\n<div id=\"attachment_38814\" style=\"width: 629px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38814\" class=\"size-full wp-image-38814\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans2.png\" alt=\"How to Delete Rows using QlikView Transformation Wizard\" width=\"619\" height=\"447\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans2.png 619w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans2-150x108.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans2-300x217.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans2-520x376.png 520w\" sizes=\"auto, (max-width: 619px) 100vw, 619px\" \/><\/a><p id=\"caption-attachment-38814\" class=\"wp-caption-text\">How to Delete Rows using QlikView Transformation Wizard &#8211;\u00a0Selecting From Source<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-quick-chart-wizard\/\">Must Read &#8211; Quick Chart Wizard in QlikView<\/a><\/strong><\/p>\n<h4 align=\"justify\">iii. File Wizard<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The next dialog box will File Wizard where the details of your selecte data file can see. Select EMBEDDED LABELS from the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Labels<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> drop down a list. Click on NEXT. <\/span><\/span><\/p>\n<div id=\"attachment_38815\" style=\"width: 625px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38815\" class=\"size-full wp-image-38815\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans3.png\" alt=\"How to Delete Rows using QlikView Transformation Wizard\" width=\"615\" height=\"477\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans3.png 615w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans3-150x116.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans3-300x233.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans3-520x403.png 520w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/a><p id=\"caption-attachment-38815\" class=\"wp-caption-text\">How to Delete Rows using QlikView Transformation Wizard &#8211;\u00a0File Wizard<\/p><\/div>\n<h4 align=\"justify\">iv. Enabling Transformation<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">On clicking <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Next<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">, you will get a Transform window asking your confirmation to initiate the transformation wizard. Click on <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Enable Transformation Step<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">.\u00a0<\/span><\/span><\/p>\n<div id=\"attachment_38816\" style=\"width: 619px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38816\" class=\"size-full wp-image-38816\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans4.png\" alt=\"How to Delete Rows using QlikView Transformation Wizard\" width=\"609\" height=\"459\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans4.png 609w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans4-150x113.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans4-300x226.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans4-520x392.png 520w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/a><p id=\"caption-attachment-38816\" class=\"wp-caption-text\">Deleting Rows using QlikView Transformation Wizard &#8211;\u00a0Enabling Transformation<\/p><\/div>\n<h4 align=\"justify\">v. Transformation Type<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Now you will have the data in tabular form. In the Garbage Tab, deletion is done. We have selected the last two rows as they were not required in the yearly sales analysis. By clicking on <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Delete Marked<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">, the marked or selected rows will get deleted. Click on NEXT.\u00a0<\/span><\/span><\/p>\n<div id=\"attachment_38817\" style=\"width: 617px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38817\" class=\"size-full wp-image-38817\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans5.png\" alt=\"How to Delete Rows using QlikView Transformation Wizard\" width=\"607\" height=\"445\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans5.png 607w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans5-150x110.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans5-300x220.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans5-520x381.png 520w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/a><p id=\"caption-attachment-38817\" class=\"wp-caption-text\">Deleting Rows using QlikView Transformation Wizard &#8211;\u00a0Transformation Type<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-themes-in-layout\/\">Do you know how to apply QlikView Layout Themes?<\/a><\/strong><\/p>\n<h4 align=\"justify\">vi. Transformation Options<\/h4>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif;font-size: large\"><u>I<\/u><\/span><span style=\"font-family: Arial, serif;font-size: medium\">n the next window, you will have the transformed table after deletion. Again, select <\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Embedded Labels<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> to make the first rows as labels and click on <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Finish<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">.\u00a0<\/span><\/span><\/p>\n<div id=\"attachment_38818\" style=\"width: 621px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38818\" class=\"size-full wp-image-38818\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans6.png\" alt=\"How to Delete Rows using QlikView Transformation Wizard\" width=\"611\" height=\"441\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans6.png 611w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans6-150x108.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans6-300x217.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans6-520x375.png 520w\" sizes=\"auto, (max-width: 611px) 100vw, 611px\" \/><\/a><p id=\"caption-attachment-38818\" class=\"wp-caption-text\">Deleting Rows using QlikView Transformation Wizard &#8211;\u00a0Transformation Options<\/p><\/div>\n<h4 align=\"justify\">vii. Load Transformed Script<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Upon clicking FINISH, new script will automatically get loaded with the code showing changes made. Save the script and document in .qvw extension and click <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Ok<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">.<\/span><\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">LOAD Month, \r\n     SalesVolume\r\nFROM\r\n[C:\\User\\admin\\Desktop\\Dataflair\\Salesvol.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq, filters(\r\nRemove(Row, Pos (Top, 15)),\r\nRemove(Row, Pos (Top, 14))\r\n));<\/pre>\n<div id=\"attachment_38819\" style=\"width: 643px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans7.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38819\" class=\"size-full wp-image-38819\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans7.png\" alt=\"How to Delete Rows using QlikView Transformation Wizard\" width=\"633\" height=\"691\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans7.png 633w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans7-137x150.png 137w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans7-275x300.png 275w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans7-520x568.png 520w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><\/a><p id=\"caption-attachment-38819\" class=\"wp-caption-text\">Deleting Rows using QlikView Transformation Wizard &#8211;\u00a0Load Transformed Script<\/p><\/div>\n<h4 align=\"justify\">viii. Displaying Table<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Reload the new script by CTRL+R or by the icon in the toolbar. Create a table box to get the transformed data displayed on the screen.\u00a0<\/span><\/span><\/p>\n<div id=\"attachment_38820\" style=\"width: 783px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans8.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38820\" class=\"size-full wp-image-38820\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans8.png\" alt=\"How to Delete Rows using QlikView Transformation Wizard\" width=\"773\" height=\"717\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans8.png 773w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans8-150x139.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans8-300x278.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans8-768x712.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans8-520x482.png 520w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/a><p id=\"caption-attachment-38820\" class=\"wp-caption-text\">Deleting Rows using QlikView Transformation Wizard &#8211; Displaying Table<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-operators\/\">Include this in your learnings &#8211; Operators in QlikView<\/a><\/strong><\/p>\n<div id=\"attachment_38821\" style=\"width: 261px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans9.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38821\" class=\"size-full wp-image-38821\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans9.png\" alt=\"How to Delete Rows using QlikView Transformation Wizard\" width=\"251\" height=\"343\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans9.png 251w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans9-110x150.png 110w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/trans9-220x300.png 220w\" sizes=\"auto, (max-width: 251px) 100vw, 251px\" \/><\/a><p id=\"caption-attachment-38821\" class=\"wp-caption-text\">How to Delete Rows &#8211;\u00a0Displaying Table<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">As you can see, the last two rows have been deleted from the final table. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">So, this was all about QlikView Transformation Wizard Tutorial. Hope you like our explanation.<\/span><\/span><\/p>\n<h3 align=\"justify\">Conclusion<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Hence, we studied the garbage tab or marked deletion using the transformation wizard in QlikView. It makes data modification much easier and faster. Furthermore, if miss something or you have any query, feel free to ask in the comment box.<\/span><\/span><\/p>\n<p align=\"justify\">Related Topic &#8211;<strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-server-load-sharing-clustering\/\">\u00a0QlikView Server Load Sharing<\/a><\/strong><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/help.qlik.com\/en-US\/qlikview\/November2017\/Subsystems\/Client\/Content\/File_Wizard_Transform.htm\">Reference<\/a><\/strong><\/p>\n<p><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1731,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/File_Wizard_Transform.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20201026063345\\\/https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/File_Wizard_Transform.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 21:22:39&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-09 05:54:28&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-13 03:20:55&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-30 06:05:34&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-18 11:09:02&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-23 08:41:37&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-16 06:01:17&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-06-19 06:53:26&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-29 10:32:41&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-29 10:32:41&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this section of the tutorial, we will learn about what is\u00a0QlikView transformation wizard and its functions. Moreover, we will learn how to use\u00a0transformation wizard\u00a0and\u00a0deletion or Garbage tab of the transformation wizard in QlikView.&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":38828,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17340,17341,17342,17337,17338,17339],"class_list":["post-38717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-functions-of-transformation-wizard","tag-qlikview-file-wizard","tag-qlikview-transform-wizard","tag-qlikview-transformation-wizard","tag-transformation-wizard-in-qlikview","tag-use-qlikview-transformation-wizard"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Transformation Wizard\u00a0- How to Delete Rows in QlikView - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Transformation Wizard\u00a0- How to Use Transformation Wizard\u00a0in QlikView,steps to delete row in Transformation Wizard, functions of File Transform\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Transformation Wizard\u00a0- How to Delete Rows in QlikView - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Transformation Wizard\u00a0- How to Use Transformation Wizard\u00a0in QlikView,steps to delete row in Transformation Wizard, functions of File Transform\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-13T12:21:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:50:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Transformation Wizard\u00a0- How to Delete Rows in QlikView - DataFlair","description":"QlikView Transformation Wizard\u00a0- How to Use Transformation Wizard\u00a0in QlikView,steps to delete row in Transformation Wizard, functions of File Transform","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:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Transformation Wizard\u00a0- How to Delete Rows in QlikView - DataFlair","og_description":"QlikView Transformation Wizard\u00a0- How to Use Transformation Wizard\u00a0in QlikView,steps to delete row in Transformation Wizard, functions of File Transform","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-13T12:21:38+00:00","article_modified_time":"2021-12-07T05:50:20+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Transformation Wizard\u00a0&#8211; How to Delete Rows in QlikView","datePublished":"2018-11-13T12:21:38+00:00","dateModified":"2021-12-07T05:50:20+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/"},"wordCount":1114,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01.jpg","keywords":["Functions of Transformation Wizard","QlikView File Wizard","QlikView Transform Wizard","QlikView Transformation Wizard","Transformation Wizard\u00a0in QlikView","Use\u00a0QlikView Transformation Wizard"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/","name":"QlikView Transformation Wizard\u00a0- How to Delete Rows in QlikView - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01.jpg","datePublished":"2018-11-13T12:21:38+00:00","dateModified":"2021-12-07T05:50:20+00:00","description":"QlikView Transformation Wizard\u00a0- How to Use Transformation Wizard\u00a0in QlikView,steps to delete row in Transformation Wizard, functions of File Transform","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Transformation-Wizard-01.jpg","width":1200,"height":628,"caption":"QlikView Transformation Wizard\u00a0- How to Delete Rows in QlikView"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-transformation-wizard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"QlikView Transformation Wizard\u00a0&#8211; How to Delete Rows in QlikView"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=38717"}],"version-history":[{"count":8,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38717\/revisions"}],"predecessor-version":[{"id":104957,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38717\/revisions\/104957"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/38828"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=38717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=38717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=38717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}