{"id":29057,"date":"2018-09-29T17:59:01","date_gmt":"2018-09-29T12:29:01","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=27601"},"modified":"2021-12-07T11:24:15","modified_gmt":"2021-12-07T05:54:15","slug":"qlikview-join-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/","title":{"rendered":"QlikView Join Functions \u2013 Types & Practical Examples of Joins"},"content":{"rendered":"

In our last session, we understood the <\/span><\/span>QlikView system requirements<\/b><\/span><\/span><\/a>. Today, we will start our new chapter called QlikView Join Tutorial, in which we start with the definition of QlikView Join function. Moreover, we will discuss the different types of Joins in QlikView: Left, Right, Inner, Outer join with examples.<\/span><\/span><\/p>\n

So, let\u2019s start QlikView Join with examples.<\/span><\/span><\/p>\n

\"QlikView<\/a>

QlikView Join Functions \u2013 Types & Practical Examples of Joins<\/p><\/div>\n

What is QlikView Joins?<\/h3>\n

The function \u2018Join\u2019 is used to join or merge data records from two or more tables. It is different from concatenating function as the join function merges or combines similar rows in two tables into one row while concatenating function simple joins two tables even if the rows are repetitive. <\/span><\/span><\/p>\n

The resultant table after applying QlikView joins function depends upon what condition or what kind of join clause has been specified in the <\/span><\/span>script<\/b><\/span><\/a><\/span>. Only the rows and column which satisfy the conditions are displayed.<\/span><\/span><\/p>\n

Do you know How to Create QlikView List & Multi Box?<\/a><\/strong><\/p>\n

QlikView Join \u2013 Types & Practical Example<\/h3>\n

There are four different kinds of QlikView Join functions through which you can decide the way in which the tables will merge their information into one. To show you how and where to apply Join in QlikView, we have taken two sample data (CSV) files. One showing the product ID and product type and another file having product name of certain data entries.<\/span><\/span><\/p>\n

QlikView Join Example-<\/strong><\/span><\/span><\/h3>\n

INPUT DATA- Product list<\/strong><\/span><\/span><\/p>\n

Product_Id,Product_Type<\/span><\/p>\n

pr1, Sporting Goods<\/span><\/p>\n

pr2, “Food, Beverages & Tobacco”<\/span><\/p>\n

pr3, Apparel & Accessories<\/span><\/p>\n

pr4, Sporting Goods<\/span><\/p>\n

pr5,Health & Beauty<\/span><\/p>\n

pr6,Arts & Entertainment<\/span><\/p>\n

pr7,Arts & Entertainment<\/span><\/p>\n

pr8,Arts & Entertainment<\/span><\/p>\n

Let’s explore the DIfference Between Power BI and QlikView<\/strong><\/a><\/p>\n

Product Name:<\/b><\/span><\/span><\/p>\n

Product_Id,Product_Type,Product_name<\/span><\/p>\n

pr5,Health & Beauty,Body Lotion<\/span><\/p>\n

pr6,Arts & Entertainment,Musical Instruments<\/span><\/p>\n

pr7, Arts & Entertainment, Orchestra Accessories<\/span><\/p>\n

pr8,Arts & Entertainment,Crafting Materials<\/span><\/p>\n

pr9, Hardware, Power Tool Batteries<\/span><\/p>\n

pr10,Home & Garden,Bath Caddies<\/span><\/p>\n

pr11,”Food, Beverages & Tobacco”,Frozen Vegetables<\/span><\/p>\n

pr12,Home & Garden,Power Equipment<\/span><\/p>\n

pr13, Home & Garden, Water Hose<\/span><\/p>\n

pr14,Health & Beauty,Aloevera Gel<\/span><\/p>\n

pr15,Health & Beauty,Face pack<\/span><\/p>\n

In the next step, we have loaded these two data files into memory and will apply different QlikView Join functions on this script now.<\/span><\/span><\/p>\n

a. QlikView Inner Join<\/h4>\n

The inner join in QlikView will merge and display only those rows which are common in both the tables (left and right). Apply Inner Join in the script editor.\u00a0<\/span><\/span><\/p>\n

Name:\r\nLOAD Product_Id,\r\n     Product_Type,\r\n     Product_name\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productname.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nINNER JOIN(Name)\r\nLOAD Product_Id,\r\n     Product_Type,\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Product List.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n
\"QlikView<\/a>
QlikView Join Functions \u2013 QlikView Inner Join<\/p><\/div>\n
Save and reload the script then create a table b<\/span><\/span>ox<\/span><\/span>. In the properties window, you will have all the fields with the common data values. In our sample files, upon creating a table box, three fields-product ID, type and name will be shown. The final table box shows rows of ID 5 to 8 because they are common in both tables.<\/span><\/span><\/p>\n
Do you know what is QlikView Database Connection & Inline data?<\/a><\/strong><\/p>\n
\"QlikView<\/a>
QlikView Join Functions \u2013 QlikView Inner Join<\/p><\/div>\n
b. QlikView Left Join<\/h4>\n
While talking about joining feature, there is terminology used- Left and Right tables. The left table in our sample in the table \u2018Productname\u2019 and the right table is \u2018Productlist\u2019.<\/span><\/span><\/p>\n
Name:\r\nLOAD Product_Id,\r\n     Product_Type,\r\n     Product_name\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productname.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nLEFT JOIN(Name)\r\nLOAD Product_Id,\r\n     Product_Type,\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Product List.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n
\"QlikView<\/a>
QlikView Join Functions \u2013 QlikView Left Join<\/p><\/div>\n
The Left Join function in QlikView, keeps the left table intact or in other words fetches all the information from the left table but takes only the common or matching rows from the right table. To understand better, refer to the screenshots attached below.\u00a0<\/span><\/span><\/p>\n
\"QlikView<\/a>
QlikView Join Functions \u2013 QlikView Left Join<\/p><\/div>\n
c. QlikView Right Join<\/h4>\n
Applying the same logic as in the left join. QlikView Right Join function fetches all the rows from the right table but only the common or matching rows from the left table.<\/span><\/span><\/p>\n
Name:\r\nLOAD Product_Id,\r\n     Product_Type,\r\n     Product_name\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productname.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nRIGHT JOIN(Name)\r\nLOAD Product_Id,\r\n     Product_Type,\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Product List.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n
\"QlikView<\/a>
QlikView Join Functions \u2013 QlikView Right Join<\/p><\/div>\n
As you can see in the system screenshots below, the column under the field name \u2018Product name\u2019 is left empty in front of the values for which the relevant information is not available and it displays the product name where it is available.<\/span><\/span><\/p>\n
Let’s explore the QlikView Careers Opportunities and Jobs Trends<\/a><\/strong><\/p>\n
d. QlikView Outer Join<\/h4>\n
The QlikView Outer Join merges all the rows from both the left and right tables showing one complete table.<\/span><\/span><\/p>\n
Name:\r\nLOAD Product_Id,\r\n     Product_Type,\r\n     Product_name\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productname.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nOUTER JOIN(Name)\r\nLOAD Product_Id,\r\n     Product_Type,\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Product List.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n
\"QlikView<\/a>
QlikView Join Functions \u2013 QlikView Outer Join<\/p><\/div>\n
\"QlikView<\/a>
QlikView Join Functions \u2013 QlikView Outer Join<\/p><\/div>\n
So, this was all about QlikView Join Function. Hope you like our explanation.<\/span><\/span><\/p>\n
Conclusion<\/h3>\n
Hence, QlikView join function helps in eliminating redundant data and keeping only on set of values while merging several tables. One thing to keep in mind is that only those tables which have values in common can be joined by this function. <\/span><\/span><\/p>\n
Else, if you know well about the<\/span><\/span> join function of SQL <\/b><\/span><\/a><\/span>you wouldn\u2019t have a tough time learning this as both are fundamentally similar. Furthermore, if we miss something or you wanna ask query? Feel free to share with us!<\/span><\/span><\/p>\n
Related Topic – QlikView Dashboard<\/a><\/strong><\/span><\/span><\/p>\n
For Reference<\/span><\/a><\/strong><\/span><\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
In our last session, we understood the QlikView system requirements. Today, we will start our new chapter called QlikView Join Tutorial, in which we start with the definition of QlikView Join function. Moreover, we...<\/p>\n","protected":false},"author":6,"featured_media":37020,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[11001,11015,11016,11019,11047,11051,15075,15880],"class_list":["post-29057","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-qlikview-inner-join","tag-qlikview-join-example","tag-qlikview-join-tutorial","tag-qlikview-left-join","tag-qlikview-outer-join","tag-qlikview-right-join","tag-types-of-joins-in-qlikview","tag-what-is-qlikview-join"],"yoast_head":"\nQlikView Join Functions \u2013 Types & Practical Examples of Joins - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Join Functions tutorial \u2013 Types of joins in QlikView, QlikView Join Example, QlikView Left join, QlikView Right join, QlikView Inner and outer join\" \/>\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-join-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Join Functions \u2013 Types & Practical Examples of Joins - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Join Functions tutorial \u2013 Types of joins in QlikView, QlikView Join Example, QlikView Left join, QlikView Right join, QlikView Inner and outer join\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/\" \/>\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-09-29T12:29:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:54:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Join-Functions-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=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Join Functions \u2013 Types & Practical Examples of Joins - DataFlair","description":"QlikView Join Functions tutorial \u2013 Types of joins in QlikView, QlikView Join Example, QlikView Left join, QlikView Right join, QlikView Inner and outer join","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-join-functions\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Join Functions \u2013 Types & Practical Examples of Joins - DataFlair","og_description":"QlikView Join Functions tutorial \u2013 Types of joins in QlikView, QlikView Join Example, QlikView Left join, QlikView Right join, QlikView Inner and outer join","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-09-29T12:29:01+00:00","article_modified_time":"2021-12-07T05:54:15+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Join-Functions-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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Join Functions \u2013 Types & Practical Examples of Joins","datePublished":"2018-09-29T12:29:01+00:00","dateModified":"2021-12-07T05:54:15+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/"},"wordCount":891,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Join-Functions-01.jpg","keywords":["QlikView Inner join","QlikView Join Example","QlikView Join Tutorial","QlikView Left join","QlikView outer join","QlikView Right join","Types of joins in QlikView","What is QlikView Join"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/","name":"QlikView Join Functions \u2013 Types & Practical Examples of Joins - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Join-Functions-01.jpg","datePublished":"2018-09-29T12:29:01+00:00","dateModified":"2021-12-07T05:54:15+00:00","description":"QlikView Join Functions tutorial \u2013 Types of joins in QlikView, QlikView Join Example, QlikView Left join, QlikView Right join, QlikView Inner and outer join","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Join-Functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Join-Functions-01.jpg","width":1200,"height":628,"caption":"QlikView Join Functions \u2013 Types & Practical Examples of Joins"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/#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 Join Functions \u2013 Types & Practical Examples of Joins"}]},{"@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\/29057","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=29057"}],"version-history":[{"count":11,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/29057\/revisions"}],"predecessor-version":[{"id":105183,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/29057\/revisions\/105183"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/37020"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=29057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=29057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=29057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}