{"id":9545,"date":"2010-01-01T00:00:13","date_gmt":"2010-01-01T05:00:13","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=9545"},"modified":"2017-11-07T09:35:15","modified_gmt":"2017-11-07T14:35:15","slug":"performing-an-inner-join-with-the-iri-workbench-demonstration","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/","title":{"rendered":"Performing an Inner Join with the IRI Workbench Demonstration [video]"},"content":{"rendered":"<p>This demonstration shows how to create an inner join job for CoSort using the IRI Workbench. The join is accomplished using the SortCL tool in CoSort and the Workbench creates the job script using the SortCL language.<\/p>\n<p style=\"text-align: center;\"><iframe loading=\"lazy\" width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/vldvUG1tZp4?feature=oembed\" frameborder=\"0\" gesture=\"media\" allowfullscreen><\/iframe><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This demonstration shows how to create an inner join job for CoSort using the IRI Workbench. The join is accomplished using the SortCL tool in CoSort and the Workbench creates the job script using the SortCL language. &nbsp;<\/p>\n","protected":false},"author":10,"featured_media":11848,"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-9545","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 an Inner Join with the IRI Workbench 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-an-inner-join-with-the-iri-workbench-demonstration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performing an Inner Join with the IRI Workbench Demonstration [video]\" \/>\n<meta property=\"og:description\" content=\"This demonstration shows how to create an inner join job for CoSort using the IRI Workbench. The join is accomplished using the SortCL tool in CoSort and the Workbench creates the job script using the SortCL language. &nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2010-01-01T05:00:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-07T14:35:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"692\" \/>\n\t<meta property=\"og:image:height\" content=\"477\" \/>\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-an-inner-join-with-the-iri-workbench-demonstration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/\"},\"author\":{\"name\":\"Susan Gegner\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\"},\"headline\":\"Performing an Inner Join with the IRI Workbench Demonstration [video]\",\"datePublished\":\"2010-01-01T05:00:13+00:00\",\"dateModified\":\"2017-11-07T14:35:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/\"},\"wordCount\":58,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.png\",\"articleSection\":[\"IRI Workbench\",\"VLOG\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/\",\"url\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/\",\"name\":\"Performing an Inner Join with the IRI Workbench Demonstration [video] - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.png\",\"datePublished\":\"2010-01-01T05:00:13+00:00\",\"dateModified\":\"2017-11-07T14:35:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.png\",\"width\":692,\"height\":477,\"caption\":\"inner join image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performing an Inner Join with the IRI Workbench 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 an Inner Join with the IRI Workbench 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-an-inner-join-with-the-iri-workbench-demonstration\/","og_locale":"en_US","og_type":"article","og_title":"Performing an Inner Join with the IRI Workbench Demonstration [video]","og_description":"This demonstration shows how to create an inner join job for CoSort using the IRI Workbench. The join is accomplished using the SortCL tool in CoSort and the Workbench creates the job script using the SortCL language. &nbsp;","og_url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/","og_site_name":"IRI","article_published_time":"2010-01-01T05:00:13+00:00","article_modified_time":"2017-11-07T14:35:15+00:00","og_image":[{"width":692,"height":477,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.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-an-inner-join-with-the-iri-workbench-demonstration\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/"},"author":{"name":"Susan Gegner","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63"},"headline":"Performing an Inner Join with the IRI Workbench Demonstration [video]","datePublished":"2010-01-01T05:00:13+00:00","dateModified":"2017-11-07T14:35:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/"},"wordCount":58,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.png","articleSection":["IRI Workbench","VLOG"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/","url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/","name":"Performing an Inner Join with the IRI Workbench Demonstration [video] - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.png","datePublished":"2010-01-01T05:00:13+00:00","dateModified":"2017-11-07T14:35:15+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2010\/01\/inner-join-image.png","width":692,"height":477,"caption":"inner join image"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/performing-an-inner-join-with-the-iri-workbench-demonstration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Performing an Inner Join with the IRI Workbench 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\/inner-join-image.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9545"}],"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=9545"}],"version-history":[{"count":6,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9545\/revisions"}],"predecessor-version":[{"id":11849,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9545\/revisions\/11849"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11848"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=9545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=9545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=9545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}