{"id":9543,"date":"2010-01-01T00:00:21","date_gmt":"2010-01-01T05:00:21","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=9543"},"modified":"2017-11-07T09:33:57","modified_gmt":"2017-11-07T14:33:57","slug":"performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/","title":{"rendered":"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video]"},"content":{"rendered":"<p>This demonstration shows how to create a left outer join where the match is based on one field and we use the ONLY parameter to discard matches. This join job is performed in CoSort using IRI Workbench. The join is accomplished using the SortCL tool in CoSort. IRI Workbench is used to create the job script using the SortCL language, and then it runs the job script.<\/p>\n<p style=\"text-align: center;\"><iframe loading=\"lazy\" width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/8Q5O18fbuUY?feature=oembed\" frameborder=\"0\" gesture=\"media\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This demonstration shows how to create a left outer join where the match is based on one field and we use the ONLY parameter to discard matches. This join job is performed in CoSort using IRI Workbench. The join is accomplished using the SortCL tool in CoSort. IRI Workbench is used to create the job<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/\" title=\"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video]\">Read More<\/a><\/div>\n","protected":false},"author":10,"featured_media":11846,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[91,1030],"tags":[],"class_list":["post-9543","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-iri-workbench","category-vlog"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video] - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video]\" \/>\n<meta property=\"og:description\" content=\"This demonstration shows how to create a left outer join where the match is based on one field and we use the ONLY parameter to discard matches. This join job is performed in CoSort using IRI Workbench. The join is accomplished using the SortCL tool in CoSort. IRI Workbench is used to create the jobRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2010-01-01T05:00:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-07T14:33:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png\" \/>\n\t<meta property=\"og:image:width\" content=\"698\" \/>\n\t<meta property=\"og:image:height\" content=\"433\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Susan Gegner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Susan Gegner\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/\"},\"author\":{\"name\":\"Susan Gegner\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\"},\"headline\":\"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video]\",\"datePublished\":\"2010-01-01T05:00:21+00:00\",\"dateModified\":\"2017-11-07T14:33:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/\"},\"wordCount\":91,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png\",\"articleSection\":[\"IRI Workbench\",\"VLOG\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/\",\"url\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/\",\"name\":\"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video] - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png\",\"datePublished\":\"2010-01-01T05:00:21+00:00\",\"dateModified\":\"2017-11-07T14:33:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png\",\"width\":698,\"height\":433,\"caption\":\"left outer join\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\",\"name\":\"Susan Gegner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"caption\":\"Susan Gegner\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/susang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video] - IRI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/","og_locale":"en_US","og_type":"article","og_title":"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video]","og_description":"This demonstration shows how to create a left outer join where the match is based on one field and we use the ONLY parameter to discard matches. This join job is performed in CoSort using IRI Workbench. The join is accomplished using the SortCL tool in CoSort. IRI Workbench is used to create the jobRead More","og_url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/","og_site_name":"IRI","article_published_time":"2010-01-01T05:00:21+00:00","article_modified_time":"2017-11-07T14:33:57+00:00","og_image":[{"width":698,"height":433,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png","type":"image\/png"}],"author":"Susan Gegner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Susan Gegner"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/"},"author":{"name":"Susan Gegner","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63"},"headline":"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video]","datePublished":"2010-01-01T05:00:21+00:00","dateModified":"2017-11-07T14:33:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/"},"wordCount":91,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png","articleSection":["IRI Workbench","VLOG"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/","url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/","name":"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video] - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png","datePublished":"2010-01-01T05:00:21+00:00","dateModified":"2017-11-07T14:33:57+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png","width":698,"height":433,"caption":"left outer join"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-a-left-outer-join-where-all-matched-records-are-removed-demonstration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Performing a Left Outer Join Where All Matched Records Are Removed Demonstration [video]"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63","name":"Susan Gegner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","caption":"Susan Gegner"},"url":"https:\/\/www.iri.com\/blog\/author\/susang\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/left-outer-join.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9543"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=9543"}],"version-history":[{"count":7,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9543\/revisions"}],"predecessor-version":[{"id":11847,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9543\/revisions\/11847"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11846"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=9543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=9543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=9543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}