{"id":14922,"date":"2022-07-11T09:38:41","date_gmt":"2022-07-11T07:38:41","guid":{"rendered":"https:\/\/www.mydral.com\/?p=14922"},"modified":"2026-08-24T15:11:28","modified_gmt":"2026-08-24T13:11:28","slug":"combine-several-excel-sheets-on-knime","status":"publish","type":"post","link":"https:\/\/www.mydral.com\/en\/combine-several-excel-sheets-on-knime\/","title":{"rendered":"Combine several Excel sheets on Knime"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><div id=\"tm-row-6b00b85e87212\" class=\"vc_row vc_row-outer vc_row-fluid\"><div id=\"tm-column-6b00b85e875bf\" class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<h2 class=\"has-luminous-vivid-orange-color has-text-color wp-block-heading\" style=\"font-size: 25px; font-weight: 400;\">Introduction:<\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis: 100%;\">\n<div class=\"wp-block-group\">\n<div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-group\">\n<div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p>Today, we are going to approach a particular scenario that can appear boring but becomes simple to solve once we settled our logic.<\/p>\n<p>Let\u2019s suppose that we must analyze the sailing evolution of a company on the last three years.<\/p>\n<p>The sailing\u2019s historic is to find on an Excel file, that combines over 36 sheets (each sheet contains the sailings of a given month or year).<\/p>\n<p>To start the analyze, we must then group our different sheets into a unique one.<\/p>\n<p>Doing it manually, is an option but when the number of sheets is as high as it is in our case, it is more judicious to use <a href=\"https:\/\/www.mydral.com\/en\/knime-uk\/\">KNIME<\/a>\u2019s functionalities. Let\u2019s continue!<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<h2 class=\"has-luminous-vivid-orange-color has-text-color wp-block-heading\" style=\"font-size: 25px; font-weight: 400;\">Inputs:<\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div class=\"wp-block-group\">\n<div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p>You\u2019ll receive this Excel sheet as to proceed to our analyze.<\/p>\n<p>It contains 36 sheets grouping sailings from 01-2020 to 12-2022.<\/p>\n<\/div>\n<\/div>\n<p> <img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"337\" class=\"wp-image-15104\" style=\"width: 600px;\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/2-2.png\" alt=\"\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/2-2.png 605w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/2-2-300x169.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3 class=\"has-luminous-vivid-orange-color has-text-color wp-block-heading\">How to proceed?<\/h3>\n<p>&nbsp;<\/p>\n<p class=\"has-luminous-vivid-orange-color has-text-color wp-block-paragraph\">\n<div class=\"wp-block-group\">\n<div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p>To combine our different sheets,<strong> 4 steps<\/strong> are necessary:<\/p>\n<ol class=\"wp-block-list\" type=\"1\">\n<li>Supply an Excel file, containing sheets\/tabs that we want to combine.<\/li>\n<li>Convert the Excel sheets into variables and create a loop.<\/li>\n<li>Read the sheet corresponding to the actual variable.<\/li>\n<li>Keep data of the sheet that had just been read and skip to the next variable.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<p class=\"has-luminous-vivid-orange-color has-text-color\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"595\" height=\"193\" class=\"wp-image-15105\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/3-1.png\" alt=\"\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/3-1.png 595w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/3-1-300x97.png 300w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><\/figure>\n<p>The loop arrives to its end when all the variables had been browsed.<\/p>\n<p>&nbsp;<\/p>\n<h2 class=\"has-luminous-vivid-orange-color has-text-color wp-block-heading\" style=\"font-size: 25px; font-weight: 400;\">Step by step:<\/h2>\n<p>&nbsp;<\/p>\n<div class=\"wp-block-group\">\n<div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p>Now that we have incorporated the logic behind our method, it is time to build our workflow:<\/p>\n<h3><strong>Step 1:<\/strong><\/h3>\n<p>Double-click on the node <em>Read Excel Sheet Names\u00a0<\/em>to give the location and the file which we are working with.\u00a0That node will have 2 output columns: <em>Path\u00a0<\/em>( location of the sheet ) and <em>Sheet\u00a0<\/em>( appellation of the sheet ).<br \/>Yet it is the\u00a0<em>Sheet\u00a0<\/em>column that is important since it will be converted in the next step, into a variable.<\/p>\n<h3><strong>Step 2:<\/strong><\/h3>\n<p>The configuration of the node <em>Table row to va<\/em>riable loop starts :<\/p>\n<p> <img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"609\" class=\"wp-image-15106\" style=\"width: 600px;\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/4-1.png\" alt=\"\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/4-1.png 605w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/4-1-296x300.png 296w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>The green box is the location where we insert the columns that we want to convert into variable.<\/p>\n<p>In our case, we want to extract data for each sheet\u2019s name in the file. We then need the sheet\u2019s name, in that case <em>Sheet,<\/em>\u00a0to be in the green box to be the variable that leads to the loop. Now that we are configured, we can execute the loop.<\/p>\n<h3><strong>Step 3:<\/strong><\/h3>\n<p>Now, we are going to configure the <em>Excel Reader<\/em> loop.<\/p>\n<p>First, we are going to supply the file from which we want to extract data, then we are going to give the variable that contains the names of the sheets we are trying to combine. To do so, we need to click on the <em>Flow Variables tab.<\/em><\/p>\n<p>Click on Settings then select\u00a0<em>sheet\u00a0<\/em>in\u00a0<em>sheet_name\u00a0<\/em>as it is shown:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14931\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-2.png\" alt=\"\" width=\"549\" height=\"631\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-2.png 881w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-2-261x300.png 261w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-2-768x884.png 768w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><figcaption>Here, the sheet\u2019s name option is defined on the variable that we have created during the previous step. We get back data from the file X for the sheet that is now defined by the loop<\/figcaption><\/figure>\n<\/div>\n<h3><strong>Step 4:<\/strong><\/h3>\n<p>Last, and easiest step, it is now about configuring the <em>Loop End<\/em>\u00a0according to your preferences.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14932\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-3.png\" alt=\"\" width=\"594\" height=\"513\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-3.png 753w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-3-300x259.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><figcaption>Personally, I wish to have a new row of numbers and don\u2019t need the iteration\u2019s column.<\/figcaption><\/figure>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2 class=\"has-luminous-vivid-orange-color has-text-color wp-block-heading\" style=\"font-size: 25px; font-weight: 400;\">Result:<\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div class=\"wp-block-group\">\n<div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p>Now that all our nodes are configured, we can execute our workflow.<\/p>\n<p>Once the loop done, the final table should look like this:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14933\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-4.png\" alt=\"\" width=\"702\" height=\"360\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-4.png 919w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-4-300x154.png 300w, https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/image-4-768x394.png 768w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><figcaption>As you can see, we succeed to combine data from different sheets of our Excel file!<\/figcaption><\/figure>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2 class=\"has-luminous-vivid-orange-color has-text-color wp-block-heading\" style=\"font-size: 25px; font-weight: 400;\">Conclusion:<\/h2>\n<p>&nbsp;<\/p>\n<p>The transformation of the sheets\u2019 name into variable and the creation of a loop are the solution when you end up working with that kind of data. Your time is too precious to waste it on repetitive and tedious tasks when <a href=\"https:\/\/www.knime.com\/knimepress\/download-from-excel-to-knime\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"has-inline-color has-luminous-vivid-orange-color\">Knime<\/span><\/a> offers functionalities that allows to automate them!<\/p>\n<p>&nbsp;<\/p>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"Introduction: &nbsp; &nbsp; Today, we are going to approach a particular scenario that can appear boring but becomes simple to solve once we settled our logic. Let\u2019s suppose that we must analyze the sailing evolution of a company on the last three years. The sailing\u2019s historic is to find on an Excel file, that combines over 36 sheets (each sheet contains the sailings of a given month or year). To start the analyze, we must then group our different sheets into a unique one. Doing it manually, is an option but when the number of sheets is as high as it is in our case, it is more judicious to use KNIME\u2019s functionalities. Let\u2019s continue! &nbsp; Inputs: &nbsp; &nbsp; You\u2019ll receive this Excel sheet as to proceed to our analyze. It contains 36 sheets grouping sailings from 01-2020 to 12-2022. &nbsp; How to proceed? &nbsp; To combine our different sheets, 4 steps are necessary: Supply an Excel file, containing sheets\/tabs that we want to combine. Convert the Excel sheets into variables and create a loop. Read the sheet corresponding to the actual variable. Keep data of the sheet that had just been read and skip to the next variable. The loop arrives to its end when all the variables had been browsed. &nbsp; Step by step: &nbsp; Now that we have incorporated the logic behind our method, it is time to build our workflow: Step 1: Double-click on the node Read Excel Sheet Names\u00a0to give the location and the file which we are working with.\u00a0That node will have 2 output columns: Path\u00a0( location of the sheet ) and Sheet\u00a0( appellation of the sheet ).Yet it is the\u00a0Sheet\u00a0column that is important since it will be converted in the next step, into a variable. Step 2: The configuration of the node Table row to variable loop starts : The green box is the location where we insert the columns that we want to convert into variable. In our case, we want to extract data for each sheet\u2019s name in the file. We then need the sheet\u2019s name, in that case Sheet,\u00a0to be in the green box to be the variable that leads to the loop. Now that we are configured, we can execute the loop. Step 3: Now, we are going to configure the Excel Reader loop. First, we are going to supply the file from which we want to extract data, then we are going to give the variable that contains the names of the sheets we are trying to combine. To do so, we need to click on the Flow Variables tab. Click on Settings then select\u00a0sheet\u00a0in\u00a0sheet_name\u00a0as it is shown: Here, the sheet\u2019s name option is defined on the variable that we have created during the previous step. We get back data from the file X for the sheet that is now defined by the loop Step 4: Last, and easiest step, it is now about configuring the Loop End\u00a0according to your preferences. Personally, I wish to have a new row of numbers and don\u2019t need the iteration\u2019s column. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Result: &nbsp; &nbsp; Now that all our nodes are configured, we can execute our workflow. Once the loop done, the final table should look like this: As you can see, we succeed to combine data from different sheets of our Excel file! &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Conclusion: &nbsp; The transformation of the sheets\u2019 name into variable and the creation of a loop are the solution when you end up working with that kind of data. Your time is too precious to waste it on repetitive and tedious tasks when Knime offers functionalities that allows to automate them! &nbsp;","protected":false},"author":173,"featured_media":15150,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"pad_hide_post_author":"","_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[82],"tags":[353,89],"class_list":["post-14922","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-actualites","tag-excel","tag-knime"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Combine several Excel sheets on Knime - MYDRAL<\/title>\n<meta name=\"description\" content=\"Today, we are going to approach a scenario about KNIME in order to combine sheets, thanks to its functionalities, our 36 seets into one.\" \/>\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.mydral.com\/en\/combine-several-excel-sheets-on-knime\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Combine several Excel sheets on Knime - MYDRAL\" \/>\n<meta property=\"og:description\" content=\"Today, we are going to approach a scenario about KNIME in order to combine sheets, thanks to its functionalities, our 36 seets into one.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mydral.com\/en\/combine-several-excel-sheets-on-knime\/\" \/>\n<meta property=\"og:site_name\" content=\"MYDRAL - DATA IS POWER\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/mydral\/?fref=ts\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-11T07:38:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-24T13:11:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/MicrosoftTeams-image-1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2832\" \/>\n\t<meta property=\"og:image:height\" content=\"1877\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Crystal BODE\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MYDRAL_COM\" \/>\n<meta name=\"twitter:site\" content=\"@MYDRAL_COM\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Crystal BODE\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/\"},\"author\":{\"name\":\"Crystal BODE\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/person\\\/d7079aa5fdc756d2658f97302d46c774\"},\"headline\":\"Combine several Excel sheets on Knime\",\"datePublished\":\"2022-07-11T07:38:41+00:00\",\"dateModified\":\"2026-08-24T13:11:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/\"},\"wordCount\":663,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/MicrosoftTeams-image-1-1.png\",\"keywords\":[\"Excel\",\"Knime\"],\"articleSection\":[\"Actualit\u00e9s\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/\",\"name\":\"Combine several Excel sheets on Knime - MYDRAL\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/MicrosoftTeams-image-1-1.png\",\"datePublished\":\"2022-07-11T07:38:41+00:00\",\"dateModified\":\"2026-08-24T13:11:28+00:00\",\"description\":\"Today, we are going to approach a scenario about KNIME in order to combine sheets, thanks to its functionalities, our 36 seets into one.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/MicrosoftTeams-image-1-1.png\",\"contentUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/MicrosoftTeams-image-1-1.png\",\"width\":2832,\"height\":1877},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/combine-several-excel-sheets-on-knime\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.mydral.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Combine several Excel sheets on Knime\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#website\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/\",\"name\":\"MYDRAL - DATA IS POWER\",\"description\":\"DATA IS POWER\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mydral.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\",\"name\":\"Mydral\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/Mydral_logo.png\",\"contentUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/Mydral_logo.png\",\"width\":1718,\"height\":1394,\"caption\":\"Mydral\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/mydral\\\/?fref=ts\",\"https:\\\/\\\/x.com\\\/MYDRAL_COM\",\"https:\\\/\\\/www.instagram.com\\\/mydral_com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/10898136\\\/admin\\\/\",\"https:\\\/\\\/www.pinterest.fr\\\/mydral_com\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCpJqoSrQX5b0PRf0H6VRhdg\\\/videos?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/person\\\/d7079aa5fdc756d2658f97302d46c774\",\"name\":\"Crystal BODE\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ce52c28d4380c61563f70c164906a5c82e27fa76f9889c4f8e664920cd9c38fa?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ce52c28d4380c61563f70c164906a5c82e27fa76f9889c4f8e664920cd9c38fa?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ce52c28d4380c61563f70c164906a5c82e27fa76f9889c4f8e664920cd9c38fa?s=96&d=retro&r=g\",\"caption\":\"Crystal BODE\"},\"url\":\"https:\\\/\\\/www.mydral.com\\\/en\\\/author\\\/cbo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Combine several Excel sheets on Knime - MYDRAL","description":"Today, we are going to approach a scenario about KNIME in order to combine sheets, thanks to its functionalities, our 36 seets into one.","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.mydral.com\/en\/combine-several-excel-sheets-on-knime\/","og_locale":"en_GB","og_type":"article","og_title":"Combine several Excel sheets on Knime - MYDRAL","og_description":"Today, we are going to approach a scenario about KNIME in order to combine sheets, thanks to its functionalities, our 36 seets into one.","og_url":"https:\/\/www.mydral.com\/en\/combine-several-excel-sheets-on-knime\/","og_site_name":"MYDRAL - DATA IS POWER","article_publisher":"https:\/\/www.facebook.com\/mydral\/?fref=ts","article_published_time":"2022-07-11T07:38:41+00:00","article_modified_time":"2026-08-24T13:11:28+00:00","og_image":[{"width":2832,"height":1877,"url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/MicrosoftTeams-image-1-1.png","type":"image\/png"}],"author":"Crystal BODE","twitter_card":"summary_large_image","twitter_creator":"@MYDRAL_COM","twitter_site":"@MYDRAL_COM","twitter_misc":{"Written by":"Crystal BODE","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/#article","isPartOf":{"@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/"},"author":{"name":"Crystal BODE","@id":"https:\/\/www.mydral.com\/#\/schema\/person\/d7079aa5fdc756d2658f97302d46c774"},"headline":"Combine several Excel sheets on Knime","datePublished":"2022-07-11T07:38:41+00:00","dateModified":"2026-08-24T13:11:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/"},"wordCount":663,"commentCount":0,"publisher":{"@id":"https:\/\/www.mydral.com\/#organization"},"image":{"@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/MicrosoftTeams-image-1-1.png","keywords":["Excel","Knime"],"articleSection":["Actualit\u00e9s"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/","url":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/","name":"Combine several Excel sheets on Knime - MYDRAL","isPartOf":{"@id":"https:\/\/www.mydral.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/#primaryimage"},"image":{"@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/MicrosoftTeams-image-1-1.png","datePublished":"2022-07-11T07:38:41+00:00","dateModified":"2026-08-24T13:11:28+00:00","description":"Today, we are going to approach a scenario about KNIME in order to combine sheets, thanks to its functionalities, our 36 seets into one.","breadcrumb":{"@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/#primaryimage","url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/MicrosoftTeams-image-1-1.png","contentUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/MicrosoftTeams-image-1-1.png","width":2832,"height":1877},{"@type":"BreadcrumbList","@id":"https:\/\/www.mydral.com\/combine-several-excel-sheets-on-knime\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.mydral.com\/"},{"@type":"ListItem","position":2,"name":"Combine several Excel sheets on Knime"}]},{"@type":"WebSite","@id":"https:\/\/www.mydral.com\/#website","url":"https:\/\/www.mydral.com\/","name":"MYDRAL - DATA IS POWER","description":"DATA IS POWER","publisher":{"@id":"https:\/\/www.mydral.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mydral.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.mydral.com\/#organization","name":"Mydral","url":"https:\/\/www.mydral.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.mydral.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2017\/09\/Mydral_logo.png","contentUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2017\/09\/Mydral_logo.png","width":1718,"height":1394,"caption":"Mydral"},"image":{"@id":"https:\/\/www.mydral.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/mydral\/?fref=ts","https:\/\/x.com\/MYDRAL_COM","https:\/\/www.instagram.com\/mydral_com\/","https:\/\/www.linkedin.com\/company\/10898136\/admin\/","https:\/\/www.pinterest.fr\/mydral_com\/","https:\/\/www.youtube.com\/channel\/UCpJqoSrQX5b0PRf0H6VRhdg\/videos?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/www.mydral.com\/#\/schema\/person\/d7079aa5fdc756d2658f97302d46c774","name":"Crystal BODE","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/ce52c28d4380c61563f70c164906a5c82e27fa76f9889c4f8e664920cd9c38fa?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ce52c28d4380c61563f70c164906a5c82e27fa76f9889c4f8e664920cd9c38fa?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ce52c28d4380c61563f70c164906a5c82e27fa76f9889c4f8e664920cd9c38fa?s=96&d=retro&r=g","caption":"Crystal BODE"},"url":"https:\/\/www.mydral.com\/en\/author\/cbo\/"}]}},"views":3497,"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2022\/06\/MicrosoftTeams-image-1-1.png","_links":{"self":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/14922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/users\/173"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/comments?post=14922"}],"version-history":[{"count":30,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/14922\/revisions"}],"predecessor-version":[{"id":33616,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/14922\/revisions\/33616"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media\/15150"}],"wp:attachment":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media?parent=14922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/categories?post=14922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/tags?post=14922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}