{"id":37750,"date":"2018-11-06T14:15:16","date_gmt":"2018-11-06T08:45:16","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=37750"},"modified":"2021-12-07T11:23:52","modified_gmt":"2021-12-07T05:53:52","slug":"qlikview-set-analysis","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/","title":{"rendered":"QlikView Set Analysis &#8211; How to Define Concatenate in QlikView"},"content":{"rendered":"<p>Now that we have gained a fundamental knowledge of creating and viewing different kinds of <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-sheet-object\/\"><strong>sheet objects in QlikView<\/strong><\/a>. We will now learn about some table manipulation functions called QlikView Set Analysis and Concatenation. Moreover, we will discuss set analysis expression and how to apply the QlikView set analysis function. Along with this, we will cover different types of QlikView concatenation.<\/p>\n<p>These functions prove to be very practical and time-saving when you work with huge amounts of data and complex tables.<\/p>\n<p>So, let&#8217;s start QlikView Set Analysis and\u00a0concatenation.<\/p>\n<h3>What is QlikView Set Analysis?<\/h3>\n<p>QlikView set analysis is a way of sorting and arranging data into different sets in the form of sheet objects. The name set analysis is given because it provides better ways of analyzing any given data set by segregating and structuring the data into tables and charts. The QlikView set analysis provides a context of analysis to a pre-defined or selected set of data.<\/p>\n<p>You can also turn off the association of a table with other so that it doesn\u2019t change its values upon making a selection on other tables. As we have seen in the \u2018Dashboard\u2019 tutorial and several others, that every QlikView document and every sheet by default operates as per the associative model of data.<\/p>\n<p>During the QlikView set analysis, you have the option of deactivating the association between tables and change the dynamic relationship between them into a static one.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-directory-service-connector-dsc\/\">Do you know What is QlikView Directory Service Connector (DSC)?<\/a><\/strong><\/p>\n<h3>QlikView Set Expression and its Components<\/h3>\n<p>The expression which defines the set analysis for a sheet object (charts, tables, lists etc) has a fixed syntax to it. There are two rules for QlikView set analysis expression i.e. the set expression is always written in the closed curly brackets {} and every set expression must only use an aggregate function like Sum, Avg, Count, Mix, Max etc.<\/p>\n<p>The QlikView set expression consists of three components.<\/p>\n<ul>\n<li>Identifier<\/li>\n<li>Operator<\/li>\n<li>Modifier<\/li>\n<\/ul>\n<div id=\"attachment_37774\" style=\"width: 948px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37774\" class=\"size-full wp-image-37774\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView.jpg\" alt=\"QlikView Set Expression and its Components\" width=\"938\" height=\"405\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView.jpg 938w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-150x65.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-300x130.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-768x332.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-520x225.jpg 520w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/a><p id=\"caption-attachment-37774\" class=\"wp-caption-text\">QlikView Set Expression and its Components<\/p><\/div>\n<p>Let us understand each of the components in further detail.<\/p>\n<p>In the image shown above is a sample set expression where the set expression is<\/p>\n<p><strong>{1-$&lt;Year={2012}&gt;}.<\/strong><\/p>\n<div id=\"attachment_37758\" style=\"width: 1212px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Expression-Its-Components-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37758\" class=\"wp-image-37758 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Expression-Its-Components-01.jpg\" alt=\"QlikView Set Analysis &amp; Expression - Concatenate in QlikView\" width=\"1202\" height=\"630\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Expression-Its-Components-01.jpg 1202w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Expression-Its-Components-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Expression-Its-Components-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Expression-Its-Components-01-768x403.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Expression-Its-Components-01-1024x537.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Expression-Its-Components-01-520x273.jpg 520w\" sizes=\"auto, (max-width: 1202px) 100vw, 1202px\" \/><\/a><p id=\"caption-attachment-37758\" class=\"wp-caption-text\">QlikView Set Expression and its Components<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-data-load\/\">Follow this link to know different ways to Implement Data Loading in QlikView<\/a><\/strong><\/p>\n<h4>i. Identifier<\/h4>\n<p>The identifier instructs the system as to what set of data is to be evaluated for set analysis in QlikView. There are different types of identifiers, using which you can specify which set of data records should the operations apply on.<\/p>\n<ul>\n<li>0 is for an empty set having no records.<\/li>\n<li>1 is for a set having all the values present in the record.<\/li>\n<li>$ is used for the values of the current selection.<\/li>\n<li>$1 is used for values of the previous selection.<\/li>\n<li>$_1 is for values of the next selection.<\/li>\n<\/ul>\n<h4>ii. Operator<\/h4>\n<p>The operators are used to establish and define a relation between identifiers (if more than one identifier is used). The operators are used to perform mathematical operations on the selected set of data. Take a look at the operator used in our example i.e. \u2013 and it is used between two identifiers 1 and $.<\/p>\n<p>This expression \u20181-$\u2019 translates to; subtract the current selections (represented by $) from the entire record (represented by 1) and take the resultant set of data, i.e. the data values which are not active in the current selection.<\/p>\n<p>There are different types of operators.<\/p>\n<ul>\n<li>+ i.e. a Union operator returns a union of sets.<\/li>\n<li>&#8211; i.e. an Exclusion operator returns the excluded sets.<\/li>\n<li>* known as the Intersection operator returns the data sets from both the identifiers.<\/li>\n<li>\/ called the Symmetric Difference operator which returns the data set from only one side of the two identifiers.<\/li>\n<\/ul>\n<h4>iii. Modifier<\/h4>\n<p>Modifiers contain fields that are can replace the current selection fields. That is the purpose of the modifiers i.e. to update or make changes in the selections. Such fields (one or more) can be written in the set expression under closed angle &lt;&gt; brackets with a selection criterion. In our sample, the modifier is &lt;Year={2012}&gt;. Hence, in a way, modifiers specify the fields or records to be selected furthermore.<\/p>\n<p>Suppose in our set analysis expression, we have instructed the logic to select only the values of Year fields and the values related to it. But, using the set expression, we will narrow this selection down for the operations to be performed on only the values for the year 2012.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-circular-reference\/\">Let&#8217;s Explore QlikView Circular Reference &amp; Loosely Coupled Tables<\/a><\/strong><\/p>\n<h3>How to Apply QlikView Set Analysis Function on Data?<\/h3>\n<p>Let us learn how to deactivate the association step by step:<\/p>\n<ul>\n<li><strong>DATA INPUT<\/strong><\/li>\n<\/ul>\n<p>Select the input data you wish to work with. We have used a CSV file on store product details.<\/p>\n<p><strong>Product_Id,Product_Line,Product_category,Product_quantity,Product_cost,Store Location, City<\/strong><\/p>\n<p>pr1,Sporting Goods,Winter Sports &amp; Activities,34,18000,USA,New York<\/p>\n<p>pr2,&#8221;Food, Beverages &amp; Tobacco&#8221;,Fruits &amp; Vegetables,76,7000,USA,New York<\/p>\n<p>pr3,Apparel &amp; Accessories,Uniforms,59,20000,India,Mumbai<\/p>\n<p>pr4,Sporting Goods,Rugby,25,8458,Canada,Ontario<\/p>\n<p>pr5,Health &amp; Beauty,Body Lotion,44,5500,USA,San Fransisco<\/p>\n<p>pr6,Arts &amp; Entertainment,Musical Instruments,20,25000,Germany,Berlin<\/p>\n<p>pr7,Arts &amp; Entertainment,Orchestra Accessories,15,6700,Canada,Toronto<\/p>\n<p>pr8,Arts &amp; Entertainment,Crafting Materials,67,4200,India,Bangalore<\/p>\n<p>pr9,Hardware,Power Tool Batteries,74,3600,UK,London<\/p>\n<p>pr10,Home &amp; Garden,Bath Caddies,66,2000,Germany,Berlin<\/p>\n<p>pr11,&#8221;Food, Beverages &amp; Tobacco&#8221;,Frozen Vegetables,56,5800,USA,Denver<\/p>\n<p>pr12,Home &amp; Garden,Power Equipment,87,6300,UK,Glasgow<\/p>\n<p>pr13,Home &amp; Garden,Water hose,42,7465,UK,Manchester<\/p>\n<p>pr14,Health &amp; Beauty,Aloevera Gel,46,4852,USA,Dallas<\/p>\n<p>pr15,Health &amp; Beauty,Face pack,52,5673,India,Delhi<\/p>\n<p>pr16,&#8221;Food, Beverages &amp; Tobacco&#8221;,Cereals,49,6480,Canada,Montreal<\/p>\n<p>pr17,&#8221;Food, Beverages &amp; Tobacco&#8221;,Fruit juices,58,4900,Australia,Melbourne<\/p>\n<p>pr18,Sporting Goods,Football,40,5250,USA,Michigan<\/p>\n<ul>\n<li><strong>SCRIPT LOADING<\/strong><\/li>\n<\/ul>\n<p>After selecting the data file from the source through the INSERT option given in the script editor, load the file. The script will look something like the one shown below with details of the data file you upload. Save this script and click OK to exit the script editor.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">LOAD Product_Id,\r\n     Product_Line,\r\n     Product_category,\r\n     Product_quality,\r\n     Product_cost,\r\n     [Store Location],\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productdetails.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-publisher-repository-qvpr\/\">Follow this link to know about QlikView Publisher Repository (QVPR)<\/a><\/strong><\/p>\n<ul>\n<li><strong>CREATING SHEET OBJECTS<\/strong><\/li>\n<\/ul>\n<p>Reload the script by CTRL+R and create a table box, list box and straight table chart to display the information.<\/p>\n<div id=\"attachment_37760\" style=\"width: 1241px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37760\" class=\"wp-image-37760 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set2.png\" alt=\"QlikView Set Analysis - How to Define Concatenate in QlikView\" width=\"1231\" height=\"955\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set2.png 1231w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set2-150x116.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set2-300x233.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set2-768x596.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set2-1024x794.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set2-520x403.png 520w\" sizes=\"auto, (max-width: 1231px) 100vw, 1231px\" \/><\/a><p id=\"caption-attachment-37760\" class=\"wp-caption-text\">QlikView Set Analysis &#8211; CREATING SHEET OBJECTS<\/p><\/div>\n<p>As you can see in the screenshot attached, we have created three sheet objects as mentioned above. First is a table box names \u2018Store Details\u2019 displaying all the fields. Next to it is a list box \u2018Country\u2019 showing the name of all the countries that is in the store\u2019s information data. The third table, \u2018cost sum\u2019 is a straight table chart object showing the sum of the cost of products in each product line.<\/p>\n<ul>\n<li><strong>ASSCIATIVE OBJECTS<\/strong><\/li>\n<\/ul>\n<p>All these three sheets objects are associative in nature to one another as the values within them will change as per the selections made in any one of the three sheet objects. Like, we have selected on \u2018USA\u2019 in the list box and both the rest of the boxes will also instantly filter their information to only that related to the USA. This is a typical example of data association.<\/p>\n<div id=\"attachment_37761\" style=\"width: 1159px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37761\" class=\"wp-image-37761 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set3.png\" alt=\"QlikView Set Analysis - How to Define Concatenate in QlikView\" width=\"1149\" height=\"813\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set3.png 1149w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set3-150x106.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set3-300x212.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set3-768x543.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set3-1024x725.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set3-520x368.png 520w\" sizes=\"auto, (max-width: 1149px) 100vw, 1149px\" \/><\/a><p id=\"caption-attachment-37761\" class=\"wp-caption-text\">QlikView Set Analysis &#8211; ASSCIATIVE OBJECTS<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-certification\/\">Also, Read &#8211; QlikView Certification \u2013 Exams &amp; Registration Process<\/a><\/strong><\/p>\n<ul>\n<li><strong>DISABELING SHEET ASSOCIATION<\/strong><\/li>\n<\/ul>\n<p>You can disable this sheet association by right-clicking on the straight table chart (\u2018cost sum\u2019 in our example). In the drop-down list, you will see an option CLONE. Click on CLONE and a new copy of the table will be made.<\/p>\n<div id=\"attachment_37762\" style=\"width: 1163px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37762\" class=\"wp-image-37762 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set4.png\" alt=\"QlikView Set Analysis - How to Define Concatenate in QlikView\" width=\"1153\" height=\"870\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set4.png 1153w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set4-150x113.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set4-300x226.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set4-768x579.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set4-1024x773.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set4-520x392.png 520w\" sizes=\"auto, (max-width: 1153px) 100vw, 1153px\" \/><\/a><p id=\"caption-attachment-37762\" class=\"wp-caption-text\">QlikView Set Analysis &#8211; DISABELING SHEET ASSOCIATION<\/p><\/div>\n<p>Right click on the cloned table and go to the Expressions tab if you wish to apply any specific functions and condition on data. We have put a condition so that it only shows the cost sum for stores in the USA.<\/p>\n<div id=\"attachment_37763\" style=\"width: 876px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37763\" class=\"size-full wp-image-37763\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set5.png\" alt=\"QlikView Set Analysis - How to Define Concatenate in QlikView\" width=\"866\" height=\"710\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set5.png 866w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set5-150x123.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set5-300x246.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set5-768x630.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set5-520x426.png 520w\" sizes=\"auto, (max-width: 866px) 100vw, 866px\" \/><\/a><p id=\"caption-attachment-37763\" class=\"wp-caption-text\">QlikView Set Analysis &#8211; DISABELING SHEET ASSOCIATION<\/p><\/div>\n<p>Now, after applying the desired conditions when we make a selection in any of the three tables except for the cloned one, no changes will be made in the cloned table.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-system-requirements\/\">Do you know What are the System Requirements for QlikView Version 11 &amp; 12<\/a><\/strong><\/p>\n<p>As you can see in the screenshot attached below when we selected the UK from the country list, the other two tables filtered its information for the UK but the cloned table remained the same.<\/p>\n<div id=\"attachment_37764\" style=\"width: 1341px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37764\" class=\"size-full wp-image-37764\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set6.png\" alt=\"QlikView Set Analysis - How to Define Concatenate in QlikView\" width=\"1331\" height=\"851\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set6.png 1331w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set6-150x96.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set6-300x192.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set6-768x491.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set6-1024x655.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/set6-520x332.png 520w\" sizes=\"auto, (max-width: 1331px) 100vw, 1331px\" \/><\/a><p id=\"caption-attachment-37764\" class=\"wp-caption-text\">QlikView Set Analysis &#8211; DISABELING SHEET ASSOCIATION<\/p><\/div>\n<h3>Define Concatenate in QlikView<\/h3>\n<p>QlikView comes with a feature \u2018Concatenate\u2019 which is used to join two tables together. The tables you wish to join might be a part of the same data information or be completely different in the context of data. Irrespective of column name or number, you can join tables using the concatenate function. This process is known as concatenation in QlikView.<\/p>\n<h4>i. How to Use QlikView Concatenation Function?<\/h4>\n<p>In order to apply the QlikView concatenate function, we first need to load the data files into<strong> QlikView\u2019s script<\/strong> hence memory.<\/p>\n<p>The sample data files we are using are two tables namely, Sale sold and Salesnew which has data related to sales information of a general store. The old table is of the month January and the new table is of the month February. We wish to join these two through QlikView concatenation.<\/p>\n<ul>\n<li><strong>Salesold<\/strong><\/li>\n<\/ul>\n<p><strong>Product_Id,Product_Line,Product_category,Product_quantity,Product_cost,Store Location, City,Month<\/strong><\/p>\n<p>pr1,Sporting Goods,Winter Sports &amp; Activities,34,18000,USA,New York,January<\/p>\n<p>pr2,&#8221;Food, Beverages &amp; Tobacco&#8221;,Fruits &amp; Vegetables,76,7000,USA,New York,January<\/p>\n<p>pr3,Apparel &amp; Accessories,Uniforms,59,20000,India,Mumbai,January<\/p>\n<p>pr4,Sporting Goods,Rugby,25,8458,Canada,Ontario,January<\/p>\n<p>pr5,Health &amp; Beauty,Body lotion,44,5500,USA,San Fransisco ,January<\/p>\n<p>pr6,Arts &amp; Entertainment,Musical Instruments,20,25000,Germany,Berlin,January<\/p>\n<p>pr7,Arts &amp; Entertainment,Orchestra Accessories,15,6700,Canada,Toronto,January<\/p>\n<p>pr8,Arts &amp; Entertainment,Crafting Materials,67,4200,India,Bangalore,January<\/p>\n<p>pr9,Hardware,Power Tool Batteries,74,3600,UK,London,January<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-silent-installation\/\">Have a look at &#8211; How to run\u00a0QlikView Silent Installation<\/a><\/strong><\/p>\n<ul>\n<li><strong>Salesnew<\/strong><\/li>\n<\/ul>\n<p><strong>Product_Id,Product_Line,Product_category,Product_quantity,Product_cost,Store Location, City,Month<\/strong><\/p>\n<p>pr10,Home &amp; Garden,Bath Caddies,66,2000,Germany,Berlin,February<\/p>\n<p>pr11,&#8221;Food, Beverages &amp; Tobacco&#8221;,Frozen Vegetables,56,5800,USA,Denver,February<\/p>\n<p>pr12,Home &amp; Garden,Power Equipment,87,6300,UK,Glasgow,February<\/p>\n<p>pr13,Home &amp; Garden,Water hose,42,7465,UK,Manchester,February<\/p>\n<p>pr14,Health &amp; Beauty,Aloevera Gel,46,4852,USA,Dallas,February<\/p>\n<p>pr15,Health &amp; Beauty,Face pack,52,5673,India,Delhi,February<\/p>\n<p>pr16,&#8221;Food, Beverages &amp; Tobacco&#8221;,Cereals,49,6480,Canada,Montreal,February<\/p>\n<p>pr17,&#8221;Food, Beverages &amp; Tobacco&#8221;,Fruit juices,58,4900,Australia,Melbourne,February<\/p>\n<p>pr18,Sporting Goods,Football,40,5250,USA,Michigan,February<\/p>\n<p>After loading the delimited files into QlikView\u2019s script, we apply the \u2018Concatenate\u2019 function.<\/p>\n<div id=\"attachment_37765\" style=\"width: 960px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37765\" class=\"size-full wp-image-37765\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2.png\" alt=\"QlikView Set Analysis - How to Define Concatenate in QlikView\" width=\"950\" height=\"666\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2.png 950w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-150x105.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-300x210.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-768x538.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-520x365.png 520w\" sizes=\"auto, (max-width: 950px) 100vw, 950px\" \/><\/a><p id=\"caption-attachment-37765\" class=\"wp-caption-text\">Image.1 How to Use Concatenate in QlikView<\/p><\/div>\n<p>Save the script and click OK to exit the script loader. Reload the script and go to LAYOUT or right-click anywhere on the sheet to create a Table Box.<\/p>\n<p>The fields from both the tables will be available to put in the table box. Choose accordingly.<\/p>\n<div id=\"attachment_37766\" style=\"width: 960px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37766\" class=\"size-full wp-image-37766\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-1.png\" alt=\"QlikView Set Analysis - How to Define Concatenate in QlikView\" width=\"950\" height=\"666\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-1.png 950w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-1-150x105.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-1-300x210.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-1-768x538.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc2-1-520x365.png 520w\" sizes=\"auto, (max-width: 950px) 100vw, 950px\" \/><\/a><p id=\"caption-attachment-37766\" class=\"wp-caption-text\">Image.2 How to Use Concatenate in QlikView<\/p><\/div>\n<p>Click OK to view the table.<\/p>\n<div id=\"attachment_37767\" style=\"width: 1079px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37767\" class=\"size-full wp-image-37767\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc3.png\" alt=\"QlikView Set Analysis - How to Define Concatenate in QlikView\" width=\"1069\" height=\"687\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc3.png 1069w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc3-150x96.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc3-300x193.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc3-768x494.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc3-1024x658.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/conc3-520x334.png 520w\" sizes=\"auto, (max-width: 1069px) 100vw, 1069px\" \/><\/a><p id=\"caption-attachment-37767\" class=\"wp-caption-text\">Image.3 How to Use Concatenate in QlikView<\/p><\/div>\n<p>As shown in the screenshot above, both the Sale sold and Salesnew table got concatenated or joined to form a completely new table.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-ports\/\">Let&#8217;s read about QlikView Ports and Client Communication in QlikView<\/a><\/strong><\/p>\n<h3>Types of Concatenation in QlikView<\/h3>\n<p>QlikView Concatenation can be done in three ways, which are;<\/p>\n<h4>i. Automatic Concatenation<\/h4>\n<p>In automatic concatenation in QlikView, the tables (two or more) having same fields names or number, concatenator to from a single table automatically. The number of records in the concatenated table are equal to the sum of records in all the tables which were concatenated.<\/p>\n<h4>ii. Forced Concatenation<\/h4>\n<p>Forced concatenation in QlikView is done when the tables subjected to concatenation do not have matching field names or numbers. If the user still wishes to concatenate such tables, it could be done forcefully by using the \u2018Concatenate\u2019 keyword before the LOAD statement.<\/p>\n<h4>iii. No Concatenation<\/h4>\n<p>As we saw in the automatic concatenation that if two or more than two tables save similar field names or number, they are automatically concatenated without user\u2019s permission in QlikView. To prevent this from happening, users must use the keyword \u2018NoConcatenate\u2019 in the script.<\/p>\n<p>So, this was all about QlikView Set Analysis. Hope you like our explanation.<\/p>\n<h3>Conclusion<\/h3>\n<p>Hence, both the QlikView set analysis function and concatenation function carry their own significance. With the help of set analysis, you can compare data information very easily by making any table and its information static in nature keeping others associative or dynamic.<\/p>\n<p>And the QlikView concatenation feature is we saw is a simple useful tool to collected related or unrelated information in order to make it more comprehensive. Furthermore, if you have any query, feel free to ask in the comment section.<\/p>\n<p>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><strong><a href=\"https:\/\/help.qlik.com\/en-US\/qlikview\/November2017\/Subsystems\/Client\/Content\/ChartFunctions\/SetAnalysis\/set-analysis-expressions.htm\">Reference<\/a><\/strong><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1757,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/ChartFunctions\\\/SetAnalysis\\\/set-analysis-expressions.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20190630034502\\\/http:\\\/\\\/help.qlik.com:80\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/ChartFunctions\\\/SetAnalysis\\\/set-analysis-expressions.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 22:16:52&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-14 07:53:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-17 13:18:55&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-01 21:39:29&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-08 20:11:41&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-13 02:01:29&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-16 06:31:31&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-20 07:20:12&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-11 02:41:32&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-18 09:08:38&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-11 03:46:14&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-17 03:42:20&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-24 16:16:34&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-28 23:16:52&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-07 08:17:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-15 11:45:29&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-07 12:19:51&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-07 12:19:51&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Now that we have gained a fundamental knowledge of creating and viewing different kinds of sheet objects in QlikView. We will now learn about some table manipulation functions called QlikView Set Analysis and Concatenation.&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":37757,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17032,17031,17033,17030,17034,17036,17035],"class_list":["post-37750","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-concatenate-in-qlikview","tag-qlikview-concatenate","tag-qlikview-concatenation","tag-qlikview-set-analysis","tag-qlikview-set-expression","tag-types-of-concatenation-in-qlikview","tag-what-is-qlikview-set-analysis"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Set Analysis - How to Define Concatenate in QlikView - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Set Analysis-Concatenate in QlikView,Types of QlikView Concatenation,QlikView Set Expression,Use Concatenation Function &amp; Set Analysis in QlikView\" \/>\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-set-analysis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Set Analysis - How to Define Concatenate in QlikView - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Set Analysis-Concatenate in QlikView,Types of QlikView Concatenation,QlikView Set Expression,Use Concatenation Function &amp; Set Analysis in QlikView\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/\" \/>\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-06T08:45:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:53:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Analysis-Concatenation-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1202\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\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=\"11 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Set Analysis - How to Define Concatenate in QlikView - DataFlair","description":"QlikView Set Analysis-Concatenate in QlikView,Types of QlikView Concatenation,QlikView Set Expression,Use Concatenation Function & Set Analysis in QlikView","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-set-analysis\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Set Analysis - How to Define Concatenate in QlikView - DataFlair","og_description":"QlikView Set Analysis-Concatenate in QlikView,Types of QlikView Concatenation,QlikView Set Expression,Use Concatenation Function & Set Analysis in QlikView","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-06T08:45:16+00:00","article_modified_time":"2021-12-07T05:53:52+00:00","og_image":[{"width":1202,"height":630,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Analysis-Concatenation-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":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Set Analysis &#8211; How to Define Concatenate in QlikView","datePublished":"2018-11-06T08:45:16+00:00","dateModified":"2021-12-07T05:53:52+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/"},"wordCount":2202,"commentCount":2,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Analysis-Concatenation-01.jpg","keywords":["Concatenate in QlikView","QlikView Concatenate","QlikView Concatenation","QlikView Set Analysis","QlikView Set Expression","Types of Concatenation in QlikView","What is QlikView Set Analysis"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/","name":"QlikView Set Analysis - How to Define Concatenate in QlikView - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Analysis-Concatenation-01.jpg","datePublished":"2018-11-06T08:45:16+00:00","dateModified":"2021-12-07T05:53:52+00:00","description":"QlikView Set Analysis-Concatenate in QlikView,Types of QlikView Concatenation,QlikView Set Expression,Use Concatenation Function & Set Analysis in QlikView","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Analysis-Concatenation-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Set-Analysis-Concatenation-01.jpg","width":1202,"height":630,"caption":"QlikView Set Analysis - How to Define Concatenate in QlikView"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/#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 Set Analysis &#8211; How to Define Concatenate 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\/37750","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=37750"}],"version-history":[{"count":11,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/37750\/revisions"}],"predecessor-version":[{"id":105127,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/37750\/revisions\/105127"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/37757"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=37750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=37750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=37750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}