{"id":39142,"date":"2018-11-13T17:41:31","date_gmt":"2018-11-13T12:11:31","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=39142"},"modified":"2021-12-07T11:20:21","modified_gmt":"2021-12-07T05:50:21","slug":"qlikview-delimited-file","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/","title":{"rendered":"QlikView Delimited File (CSV) &#8211;  Loading XML &amp; Web Files in QlikView"},"content":{"rendered":"<p>In our last tutorial, we studied <a href=\"https:\/\/data-flair.training\/blogs\/qvd-files\/\"><strong>QlikView Files (QVD)<\/strong><\/a>.\u00a0 Now, we talk more deeply about files: QlikView Delimited File, QlikView\u00a0XML File, and QlikView Web Files. Moreover, we will learn\u00a0<span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">how to load delimited and web files in QlikView.<\/span><\/span><\/p>\n<p>So, let&#8217;s start QlikView Delimited File.<\/p>\n<div id=\"attachment_39149\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39149\" class=\"size-full wp-image-39149\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01.jpg\" alt=\"QlikView Delimited File (CSV) - QlikView XML and Web Files\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-39149\" class=\"wp-caption-text\">QlikView Delimited File (CSV) &#8211; QlikView XML and Web Files<\/p><\/div>\n<h3 align=\"justify\">QlikView Delimited File (CSV File)<\/h3>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">A QlikView delimited file is a simple text file in which the data fields are separated by a comma, semicolon, tabs etc. Such files are called CSV (comma separated values) files and they also save in .csv format extension. You can load CSV files in QlikView. Such data files are useful as they can store huge data in a simple text form.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-trellis\/\">Do you know what is QlikView Trellis and how to apply it?<\/a><\/strong><\/p>\n<h4 align=\"justify\">a. How to Load QlikView Delimited file (CSV)?<\/h4>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Following are the steps to load delimited or CSV files in Qlikview.<\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Press CTRL+E to get the script editor on the screen. <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Go to INSERT and select LOAD STATEMENT then select LOAD FROM FILE.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<div id=\"attachment_39150\" style=\"width: 1285px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39150\" class=\"size-full wp-image-39150\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt1.png\" alt=\"QlikView Delimited File\" width=\"1275\" height=\"733\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt1.png 1275w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt1-150x86.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt1-300x172.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt1-768x442.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt1-1024x589.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt1-520x299.png 520w\" sizes=\"auto, (max-width: 1275px) 100vw, 1275px\" \/><\/a><p id=\"caption-attachment-39150\" class=\"wp-caption-text\">Step. 2 Load Delimited File in\u00a0QlikView<\/p><\/div>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Choose a CSV (.csv) file from a proper path.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">You can choose a CSV data file from the TABLE FILES option present at the bottom right of the script editor.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Next, you will see a File Wizard dialogue box. Select EMBEDDED LABELS in the LABELS tab to set the first row as the field names. If you notice at the left of this box. You will that the file type is automatically selected as DELIMITED. Next click on FINISH.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<div id=\"attachment_39151\" style=\"width: 1287px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39151\" class=\"size-full wp-image-39151\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt2.png\" alt=\"QlikView Delimited File\" width=\"1277\" height=\"759\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt2.png 1277w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt2-150x89.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt2-300x178.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt2-768x456.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt2-1024x609.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt2-520x309.png 520w\" sizes=\"auto, (max-width: 1277px) 100vw, 1277px\" \/><\/a><p id=\"caption-attachment-39151\" class=\"wp-caption-text\">Step. 5 Load Delimited File in\u00a0QlikView<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-november-2017\/\">Let&#8217;s Explore the features of QlikView November2017 (12.2)<\/a><\/strong><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">You will now have a script in front of you with the field names added to it. Click on OK.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SET MoneyFormat='$#,##0.00; ($#, ##0.00)';\r\nSET TimeFormat='h:mm:ss TT';\r\nSET DateFormat='DD\/MM\/YYYY';\r\nSET TimestampFormat='DD\/MM\/YYYY h:mm:ss[.fff] TT';\r\nSET FirstWeekDay=6;\r\nSET BrokenWeeks=1;\r\nSET ReferenceDay=0;\r\nSET FirstMonthOfYear=1;\r\nSET CollationLocale='en-US';\r\nSET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';\r\nSET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';\r\nSET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';\r\nSET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';\r\nLOAD Series_reference,\r\n     Period,\r\n     Data_value,\r\n     STATUS,\r\n     UNITS,\r\n     Subjects,\r\n     Gruops,\r\n     Series_title_1\r\nFROM\r\n[C:\\Users\\admin\\consumers-price-index-Jun18-index-numbers-csv-tables.csv.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is',', msq);<\/pre>\n<div id=\"attachment_39152\" style=\"width: 1279px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39152\" class=\"size-full wp-image-39152\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt3.png\" alt=\"QlikView Delimited File\" width=\"1269\" height=\"741\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt3.png 1269w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt3-150x88.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt3-300x175.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt3-768x448.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt3-1024x598.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt3-520x304.png 520w\" sizes=\"auto, (max-width: 1269px) 100vw, 1269px\" \/><\/a><p id=\"caption-attachment-39152\" class=\"wp-caption-text\">Step. 6 Load Delimited File in\u00a0QlikView<\/p><\/div>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Now right-click anywhere on the QlikView main screen and select NEW SHEET OBJECT then select TABLE BOX. <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">A NEW TABLE BOX will appear where you can do all the operations as discussed in the table box paragraph of Excel file.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<div id=\"attachment_39153\" style=\"width: 733px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39153\" class=\"size-full wp-image-39153\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt4.png\" alt=\"QlikView Delimited File\" width=\"723\" height=\"551\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt4.png 723w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt4-150x114.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt4-300x229.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt4-520x396.png 520w\" sizes=\"auto, (max-width: 723px) 100vw, 723px\" \/><\/a><p id=\"caption-attachment-39153\" class=\"wp-caption-text\">Step. 8 Load Delimited File in\u00a0QlikView<\/p><\/div>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">You will finally see a table box on the main tab.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<div id=\"attachment_39154\" style=\"width: 957px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39154\" class=\"size-full wp-image-39154\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt5.png\" alt=\"QlikView Delimited File\" width=\"947\" height=\"551\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt5.png 947w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt5-150x87.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt5-300x175.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt5-768x447.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dlmt5-520x303.png 520w\" sizes=\"auto, (max-width: 947px) 100vw, 947px\" \/><\/a><p id=\"caption-attachment-39154\" class=\"wp-caption-text\">Step. 9 Load Delimited File in\u00a0QlikView<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-dashboard\/\">Follow this link to know how to create QlikView Dashboard?\u00a0\u00a0<\/a><\/strong><\/p>\n<h3 align=\"justify\">QlikView XML File<\/h3>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">XML stands for <strong>Extensive Markup Language<\/strong>. It is markup language for data. As HTML markup tags shows the structure or layout of the webpage, XML file\u2019s markup tags contains data and the meaning of that data. You can share the data on the XML file. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">The QlikView XML files can share\u00a0through the\u00a0web, intranet etc. It uses the standard ASCII text and shares the data and file format.<\/span><\/span><\/p>\n<h4 align=\"justify\">a. How to Load XML Files in QlikView?<\/h4>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">You can load XML files in QlikView. The steps are same as adding excel or delimited file followed by creating a Table Box and performing further operations on it. <\/span><\/span><\/p>\n<div id=\"attachment_39155\" style=\"width: 1281px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39155\" class=\"wp-image-39155 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml1.png\" alt=\"QlikView Delimited File - QlikView XML File\" width=\"1271\" height=\"755\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml1.png 1271w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml1-150x89.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml1-300x178.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml1-768x456.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml1-1024x608.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml1-520x309.png 520w\" sizes=\"auto, (max-width: 1271px) 100vw, 1271px\" \/><\/a><p id=\"caption-attachment-39155\" class=\"wp-caption-text\">Step.1 Load XML Files in QlikView<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Once you get your file loaded in the script. A save file prom will appear asking you the name and destination of the file. Click on next step once you are done.<\/span><\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SET MoneyDecimalSep='.';\r\nSET MoneyFormat='$#,##0.00; ($#, ##0.00)';\r\nSET TimeFormat='h:mm:ss TT';\r\nSET DateFormat='DD\/MM\/YYYY';\r\nSET TimestampFormat='DD\/MM\/YYYY h:mm:ss[.fff] TT';\r\nSET FirstWeekDay=6;\r\nSET BrokenWeeks=1;\r\nSET ReferenceDay=0;\r\nSET FirstMonthOfYear=1;\r\nSET CollationLocale='en-US';\r\nSET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';\r\nSET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';\r\nSET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';\r\nSET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';\r\n\/\/ Start of [food.xml] LOAD statements\r\nfood:\r\nLOAD name,\r\n     Price,\r\n     Discription,\r\n     calories\r\nFROM\r\n[C:\\Users\\admin\\Download\\food.xml] (XmlSimple, Table is [breakfast_menu\/food]);\r\n\/\/ End of [food.xml] LOAD statements<\/pre>\n<div id=\"attachment_39156\" style=\"width: 1269px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39156\" class=\"size-full wp-image-39156\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml2.png\" alt=\"QlikView Delimited File - QlikView XML File\" width=\"1259\" height=\"739\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml2.png 1259w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml2-150x88.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml2-300x176.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml2-768x451.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml2-1024x601.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml2-520x305.png 520w\" sizes=\"auto, (max-width: 1259px) 100vw, 1259px\" \/><\/a><p id=\"caption-attachment-39156\" class=\"wp-caption-text\">Step.2 Load XML Files in QlikView<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Then perform the same steps to open and create the Table Box.<\/span><\/span><\/p>\n<div id=\"attachment_39157\" style=\"width: 941px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39157\" class=\"size-full wp-image-39157\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml3.png\" alt=\"QlikView Delimited File - QlikView XML File\" width=\"931\" height=\"363\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml3.png 931w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml3-150x58.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml3-300x117.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml3-768x299.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/xml3-520x203.png 520w\" sizes=\"auto, (max-width: 931px) 100vw, 931px\" \/><\/a><p id=\"caption-attachment-39157\" class=\"wp-caption-text\">Step.3 Load XML Files in QlikView<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-search\/\">Do you know the different types of search options in QlikView?<\/a><\/strong><\/p>\n<h3 align=\"justify\">QlikView Web Files<\/h3>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">The web files are basically HTML files. The QlikView data loading option loads the HTML files from the URL given and understands the structure of the HTML file. The process of loading a web file in Qlikview is a little different.<\/span><\/span><\/p>\n<h4 align=\"justify\">a. How to Load Web Files in QlikView?<\/h4>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Open the script editor and select WEB FILES from the DATA tab given at the bottom. Enter a URL in INTERNET FILES columns and click NEXT.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<div id=\"attachment_39158\" style=\"width: 1283px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39158\" class=\"size-full wp-image-39158\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web1.png\" alt=\"QlikView Delimited File - QlikView WEB File\" width=\"1273\" height=\"757\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web1.png 1273w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web1-150x89.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web1-300x178.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web1-768x457.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web1-1024x609.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web1-520x309.png 520w\" sizes=\"auto, (max-width: 1273px) 100vw, 1273px\" \/><\/a><p id=\"caption-attachment-39158\" class=\"wp-caption-text\">Step.1 Load Web Files in QlikView<\/p><\/div>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Now a TYPE WIZARD will appear . Click NEXT twice if you don\u2019t wish to make any changes.\u00a0<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<div id=\"attachment_39159\" style=\"width: 1261px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39159\" class=\"size-full wp-image-39159\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web2.png\" alt=\"QlikView Delimited File - QlikView Web File\" width=\"1251\" height=\"751\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web2.png 1251w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web2-150x90.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web2-300x180.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web2-768x461.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web2-1024x615.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web2-520x312.png 520w\" sizes=\"auto, (max-width: 1251px) 100vw, 1251px\" \/><\/a><p id=\"caption-attachment-39159\" class=\"wp-caption-text\">Step.2 Load Web Files in QlikView<\/p><\/div>\n<div id=\"attachment_39160\" style=\"width: 1271px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39160\" class=\"size-full wp-image-39160\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web3.png\" alt=\"QlikView Delimited File - QlikView Web File\" width=\"1261\" height=\"755\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web3.png 1261w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web3-150x90.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web3-300x180.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web3-768x460.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web3-1024x613.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web3-520x311.png 520w\" sizes=\"auto, (max-width: 1261px) 100vw, 1261px\" \/><\/a><p id=\"caption-attachment-39160\" class=\"wp-caption-text\">Step.3 Load Web Files in QlikView<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-synthetic-keys\/\">Must Read &#8211; QlikView Synthetic Keys<\/a><\/strong><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Finally, the data will be loaded in the script editor.\u00a0<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SET TimestampFormat='DD\/MM\/YYYY h:mm:ss[.fff] TT';\r\nSET FirstWeekDay=6;\r\nSET BrokenWeeks=1;\r\nSET ReferenceDay=0;\r\nSET FirstMonthOfYear=1;\r\nSET CollationLocale='en-US';\r\nSET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';\r\nSET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';\r\nSET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';\r\nSET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';\r\n\/\/ Start of [food.xml] LOAD statements\r\nfood:\r\nLOAD Rank,\r\n     \"[1]Country (or dependent territory)\",\r\n     Population,\r\n     [% of population],\r\n     \"Averagerelativeannualgrowth (%) [2]\",\r\n     \"Averageabsoluteannualgrowth [3]\",\r\n     \"Estimateddoublingtime (Years) [4]\", \r\n     [Officialfigures (whereavailable)],\r\n     [Date oflast figure],\r\n     [Regional grouping],\r\n     Source\r\nFROM\r\n[https:\/\/en.wikipedia.org\/wiki\/List_of_European_counteries_by_population]\r\n(html, utf8, embedded labels, table is @2);<\/pre>\n<div id=\"attachment_39161\" style=\"width: 1277px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39161\" class=\"size-full wp-image-39161\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web4.png\" alt=\"QlikView Delimited File - QlikView Web File\" width=\"1267\" height=\"743\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web4.png 1267w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web4-150x88.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web4-300x176.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web4-768x450.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web4-1024x600.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web4-520x305.png 520w\" sizes=\"auto, (max-width: 1267px) 100vw, 1267px\" \/><\/a><p id=\"caption-attachment-39161\" class=\"wp-caption-text\">Step.4 Load Web Files in QlikView<\/p><\/div>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Save your file and open this HTML data in any layout you wish.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<div id=\"attachment_39162\" style=\"width: 725px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39162\" class=\"size-full wp-image-39162\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web5.png\" alt=\"QlikView Delimited File - QlikView Web File\" width=\"715\" height=\"545\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web5.png 715w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web5-150x114.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web5-300x229.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web5-520x396.png 520w\" sizes=\"auto, (max-width: 715px) 100vw, 715px\" \/><\/a><p id=\"caption-attachment-39162\" class=\"wp-caption-text\">Step.5 Load Web Files in QlikView<\/p><\/div>\n<div id=\"attachment_39163\" style=\"width: 941px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-39163\" class=\"size-full wp-image-39163\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web6.png\" alt=\"QlikView Delimited File - QlikView Web File\" width=\"931\" height=\"501\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web6.png 931w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web6-150x81.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web6-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web6-768x413.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/web6-520x280.png 520w\" sizes=\"auto, (max-width: 931px) 100vw, 931px\" \/><\/a><p id=\"caption-attachment-39163\" class=\"wp-caption-text\">Step.6 Load Web Files in QlikView<\/p><\/div>\n<p align=\"justify\">So, this was all about QlikView Delimited File (CSV). Hope you like our explanation.<\/p>\n<h3 align=\"justify\">Conclusion<\/h3>\n<p><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">We have learned to load all different sorts (QlikView Delimited File, XML and Web Files) of data files into QlikView. This data is used for visualization and analysis purposes to derive useful insights from it.\u00a0Furthermore, if you have any query, feel to write to us.<\/span><\/span><\/p>\n<p>Related Topic &#8211; <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-snmp-tutorial\/\">QlikView SNMP<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/en.wikipedia.org\/wiki\/Qlik\">Reference<\/a><\/strong><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1715,&quot;href&quot;:&quot;https:\\\/\\\/en.wikipedia.org\\\/wiki\\\/Qlik&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251001171755\\\/https:\\\/\\\/en.wikipedia.org\\\/wiki\\\/Qlik&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 20:09:08&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-15 05:03:13&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-19 05:48:11&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-22 23:50:35&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-26 11:52:18&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-29 20:18:15&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-04 00:31:34&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-08 19:03:02&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-12 17:20:17&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-16 10:22:43&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-19 13:53:42&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-25 00:20:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-28 00:45:22&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-31 11:09:20&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-04 03:20:11&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-09 17:53:41&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-15 12:38:33&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-21 15:19:31&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-28 17:59:59&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-04 00:09:50&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-17 13:50:56&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-21 21:22:34&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-26 03:03:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-01 13:44:20&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-06 07:05:27&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-09 08:17:42&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-14 10:12:42&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-18 09:23:37&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-22 20:52:33&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-06 14:33:55&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-11 11:15:23&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-15 23:42:55&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-19 05:22:37&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-22 13:05:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-25 14:04:38&quot;,&quot;http_code&quot;:429},{&quot;date&quot;:&quot;2026-05-28 14:06:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-01 10:05:00&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-04 16:50:58&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-08 02:23:26&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-13 06:48:23&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-18 03:04:25&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-22 10:03:21&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-27 08:37:44&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-27 08:37:44&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our last tutorial, we studied QlikView Files (QVD).\u00a0 Now, we talk more deeply about files: QlikView Delimited File, QlikView\u00a0XML File, and QlikView Web Files. Moreover, we will learn\u00a0how to load delimited and web&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":39149,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17480,17483,17484,17482,17481],"class_list":["post-39142","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-delimited-file-in-qlikview","tag-how-to-load-delimited-or-csv-files-in-qlikview","tag-how-to-load-loading-a-web-file-in-qlikview","tag-web-files-in-qlikview","tag-xml-file-in-qlikview"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Delimited File (CSV) - Loading XML &amp; Web Files in QlikView - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Delimited File - QlikView XML File, QlikView Web Files, How to Load CSV File in QlikView, How to Load Web File in QlikView, Loading\" \/>\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-delimited-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Delimited File (CSV) - Loading XML &amp; Web Files in QlikView - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Delimited File - QlikView XML File, QlikView Web Files, How to Load CSV File in QlikView, How to Load Web File in QlikView, Loading\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/\" \/>\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:11:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:50:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-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=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Delimited File (CSV) - Loading XML &amp; Web Files in QlikView - DataFlair","description":"QlikView Delimited File - QlikView XML File, QlikView Web Files, How to Load CSV File in QlikView, How to Load Web File in QlikView, Loading","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-delimited-file\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Delimited File (CSV) - Loading XML &amp; Web Files in QlikView - DataFlair","og_description":"QlikView Delimited File - QlikView XML File, QlikView Web Files, How to Load CSV File in QlikView, How to Load Web File in QlikView, Loading","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-13T12:11:31+00:00","article_modified_time":"2021-12-07T05:50:21+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-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":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Delimited File (CSV) &#8211; Loading XML &amp; Web Files in QlikView","datePublished":"2018-11-13T12:11:31+00:00","dateModified":"2021-12-07T05:50:21+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/"},"wordCount":904,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01.jpg","keywords":["Delimited File in QlikView","how to load delimited or CSV files in Qlikview","How to Load loading a web file in Qlikview","Web Files in QlikView","XML File in QlikView"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/","name":"QlikView Delimited File (CSV) - Loading XML &amp; Web Files in QlikView - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01.jpg","datePublished":"2018-11-13T12:11:31+00:00","dateModified":"2021-12-07T05:50:21+00:00","description":"QlikView Delimited File - QlikView XML File, QlikView Web Files, How to Load CSV File in QlikView, How to Load Web File in QlikView, Loading","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-01.jpg","width":1200,"height":628,"caption":"QlikView Delimited File (CSV) - QlikView XML and Web Files"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/#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 Delimited File (CSV) &#8211; Loading XML &amp; Web Files 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\/39142","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=39142"}],"version-history":[{"count":8,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39142\/revisions"}],"predecessor-version":[{"id":104959,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39142\/revisions\/104959"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/39149"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=39142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=39142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=39142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}