{"id":6171,"date":"2020-07-30T11:45:55","date_gmt":"2020-07-30T09:45:55","guid":{"rendered":"https:\/\/www.mydral.com\/?p=6171"},"modified":"2026-08-24T16:45:12","modified_gmt":"2026-08-24T14:45:12","slug":"les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime","status":"publish","type":"post","link":"https:\/\/www.mydral.com\/en\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/","title":{"rendered":"Les 3 Minutes Analytics : comment pivoter sa table dans KNIME?"},"content":{"rendered":"<p>Comment pivoter sa table dans KNIME ? Avant tout une petite pr\u00e9sentation de votre troisi\u00e8me parcours et pas des moindres, vous avez rejoint <strong>KNIME Jedi<\/strong>, et non ce n\u2019est pas le c\u00f4t\u00e9 obscur de la force mais un pas de plus dans votre apprentissage<strong> Les 3 Minutes Analytics<\/strong>. Ce parcours est con\u00e7u pour vous enseigner l\u2019utilisation des nodes plus complexes et pour vous apporter beaucoup de pratique au passage ! Dans cet article, nous nous int\u00e9ressons au node Pivoting.<\/p>\n<p><img decoding=\"async\" class=\"emoji\" role=\"img\" draggable=\"false\" src=\"https:\/\/s.w.org\/images\/core\/emoji\/12.0.0-1\/svg\/1f39e.svg\" alt=\"&#x1f39e;\" \/> <strong>Mydral vous propose \u00e9galement de d\u00e9couvrir en vid\u00e9o ce tutoriel :\u00a0<\/strong><\/p>\n<div class=\"embed-responsive embed-responsive-16by9\"><iframe loading=\"lazy\" title=\"KN024_Pivot\" src=\"https:\/\/player.vimeo.com\/video\/441976613?h=0814cfff05&amp;dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\"><\/iframe><\/div>\n<p>&nbsp;<\/p>\n<p>Ce tutoriel est destin\u00e9 \u00e0 comprendre comment manipuler le node<strong> Pivoting<\/strong>\u00a0dans KNIME.<\/p>\n<p>Dans cet exemple, j\u2019utilise un fichier <strong>CSV<\/strong> qui concerne les commandes clients de l\u2019entreprise Sport Up et le node <strong>Pivoting.\u00a0<\/strong><\/p>\n<p>Pour configurer mon node j&rsquo;ai trois onglets:<\/p>\n<h3><strong>Goups : <\/strong><\/h3>\n<p>Dans cet onglet il y a deux parties, la premi\u00e8re concerne la colonne \u00e0 grouper et la seconde partie les param\u00e8tres avanc\u00e9s. Il est possible de choisir le nom de la colonne, d&rsquo;\u00e9viter une surcharge de la m\u00e9moire, d&rsquo;am\u00e9liorer son jeu de donn\u00e9e si celui-ci est faible et de garder l&rsquo;ordre des lignes.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6187 aligncenter\" style=\"color: #333333; font-style: normal; font-weight: 300;\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting1.png\" alt=\"Pivoter une table KNIME\" width=\"763\" height=\"652\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Pivots : <\/strong><\/h3>\n<p>Cette partie se pr\u00e9sente de la m\u00eame fa\u00e7on que l&rsquo;onglet <strong>Group <\/strong>avec une partie suppl\u00e9mentaire au dessus des param\u00e8tres avanc\u00e9s, afin de choisir ou non d&rsquo;inclure les valeurs manquantes, ajouter les totaux g\u00e9n\u00e9raux et utiliser uniquement les valeurs disponibles dans les donn\u00e9es d&rsquo;entr\u00e9e.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6188 size-full aligncenter\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting2.png\" alt=\"Pivot KNIME\" width=\"795\" height=\"653\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting2.png 795w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting2-300x246.png 300w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting2-768x631.png 768w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Manual aggregation : <\/strong><\/h3>\n<p>Choix de la colonne sur laquelle je dois faire l&rsquo;agr\u00e9gation. Il existe plusieurs agr\u00e9gations possibles. Certaines d&rsquo;entre elles donnent la possibilit\u00e9 d&rsquo;inclure ou non les valeurs manquantes, \u00e0 vous de faire ce choix en fonction de vos besoins.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6189 size-full aligncenter\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting3.png\" alt=\"Pivoter sa table KNIME\" width=\"801\" height=\"657\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting3.png 801w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting3-300x246.png 300w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting3-768x630.png 768w\" sizes=\"auto, (max-width: 801px) 100vw, 801px\" \/><\/p>\n<p>Afin d&rsquo;avoir plus de d\u00e9tails sur une agr\u00e9gation je vais dans <strong>Description<\/strong> \u00e0 droite de mon onglet <strong>Settings.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6190 size-full\" style=\"color: #333333; font-style: normal; font-weight: 300;\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting4.png\" alt=\"Pivoter sa table KNIME\" width=\"793\" height=\"649\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting4.png 793w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting4-300x246.png 300w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting4-768x629.png 768w\" sizes=\"auto, (max-width: 793px) 100vw, 793px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Une fois votre node <strong>Pivoting<\/strong> param\u00e9tr\u00e9 trois table sont disponibles :<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6191 size-full\" style=\"color: #333333; font-style: normal; font-weight: 300;\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting5.png\" alt=\"Pivoter sa table KNIME \" width=\"349\" height=\"569\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting5.png 349w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting5-184x300.png 184w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><\/p>\n<h3><strong>Pivot table<\/strong><\/h3>\n<p>Est votre tableau crois\u00e9 dynamique<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6193 size-full aligncenter\" style=\"color: #333333; font-style: normal; font-weight: 300;\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotGroup.png\" alt=\"Pivot Table\" width=\"541\" height=\"268\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotGroup.png 541w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotGroup-300x149.png 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/p>\n<h3><strong>Group totals <\/strong><\/h3>\n<p>Est la colonne<strong> Group <\/strong>de votre node<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6194 size-full\" style=\"color: #333333; font-style: normal; font-weight: 300;\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotTable.png\" alt=\"Pivoter sa table dans KNIME\" width=\"825\" height=\"268\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotTable.png 825w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotTable-300x97.png 300w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotTable-768x249.png 768w\" sizes=\"auto, (max-width: 825px) 100vw, 825px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Pivot Totals<\/strong><\/h3>\n<p>Est la ligne de votre <strong>Pivots<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6195 size-full\" style=\"color: #333333; font-style: normal; font-weight: 300;\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotTotal.png\" alt=\"Node pivoter dans KNIME \" width=\"434\" height=\"166\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotTotal.png 434w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/img_pivoting_pivotTotal-300x115.png 300w\" sizes=\"auto, (max-width: 434px) 100vw, 434px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Maintenant vous savez cr\u00e9er un tableau crois\u00e9 dynamique avec le node <b>Pivoting !<\/b> Bravo \u00e0 vous, vous pouvez continuer votre parcours et atteindre le Graal !<\/p>\n<p>Vous avez commenc\u00e9 par le mauvais module ? Pas de panique ! Pour suivre nos autres modules et d\u00e9buter votre parcours <strong>KNIME Beginner,<\/strong> RDV dans notre rubrique<span style=\"color: #ff6600;\"> <a style=\"color: #ff6600;\" href=\"https:\/\/www.mydral.com\/en\/category\/les-3-minutes-analytics\/\">Les 3 Minutes Analytiques.<\/a><\/span><\/p>\n<p>Retrouvez <strong>KNIME Rookie<\/strong> and<strong> KNIME Jedi<\/strong> avant de devenir un <strong>KNIME Expert !<\/strong><\/p>\n<p>Votre parcours nous int\u00e9resse ! Parlez-nous de votre retour d\u2019exp\u00e9rience en commentaires !<\/p>\n<p>Suivez-nous sur les r\u00e9seaux sociaux :<strong><a href=\"https:\/\/www.linkedin.com\/company\/mydral\/\"><span style=\"color: #ff6600;\"> LinkedIn<\/span> <\/a><\/strong>&amp; <span style=\"color: #ff6600;\"><strong><a style=\"color: #ff6600;\" href=\"https:\/\/twitter.com\/MYDRAL_COM\">Twitter\u00a0<\/a><\/strong><\/span><\/p>","protected":false},"excerpt":{"rendered":"Vous \u00eates un KNIME Jedi et vous souhaitez aller plus loin ! Dans cet article, apprenez \u00e0 manipuler le node pivoting. Vous saurez cr\u00e9er vos TCD.","protected":false},"author":6,"featured_media":7354,"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":[1],"tags":[89,138],"class_list":["post-6171","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-la-minute-analytics","tag-knime","tag-node"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Les 3 Minutes Analytics : comment pivoter sa table dans KNIME?<\/title>\n<meta name=\"description\" content=\"Vous \u00eates un KNIME Jedi et vous souhaitez aller plus loin ! Dans cet article, apprenez \u00e0 manipuler le node pivoting. Vous saurez cr\u00e9er vos TCD.\" \/>\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\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Les 3 Minutes Analytics : comment pivoter sa table dans KNIME?\" \/>\n<meta property=\"og:description\" content=\"Vous \u00eates un KNIME Jedi et vous souhaitez aller plus loin ! Dans cet article, apprenez \u00e0 manipuler le node pivoting. Vous saurez cr\u00e9er vos TCD.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mydral.com\/en\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-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=\"2020-07-30T09:45:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-24T14:45:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN024-Pivoter.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1288\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Marius Sergent\" \/>\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=\"Marius Sergent\" \/>\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\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/\"},\"author\":{\"name\":\"Marius Sergent\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/person\\\/aeefb62ec34427c9f808ab5acd1d2da6\"},\"headline\":\"Les 3 Minutes Analytics : comment pivoter sa table dans KNIME?\",\"datePublished\":\"2020-07-30T09:45:55+00:00\",\"dateModified\":\"2026-08-24T14:45:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/\"},\"wordCount\":466,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/KN024-Pivoter.png\",\"keywords\":[\"Knime\",\"node\"],\"articleSection\":[\"La minute Analytics\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/\",\"name\":\"Les 3 Minutes Analytics : comment pivoter sa table dans KNIME?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/KN024-Pivoter.png\",\"datePublished\":\"2020-07-30T09:45:55+00:00\",\"dateModified\":\"2026-08-24T14:45:12+00:00\",\"description\":\"Vous \u00eates un KNIME Jedi et vous souhaitez aller plus loin ! Dans cet article, apprenez \u00e0 manipuler le node pivoting. Vous saurez cr\u00e9er vos TCD.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/KN024-Pivoter.png\",\"contentUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/KN024-Pivoter.png\",\"width\":1288,\"height\":720,\"caption\":\"#KN024 Pivoter sa table dans KNIME\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.mydral.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Les 3 Minutes Analytics : comment pivoter sa table dans 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\\\/aeefb62ec34427c9f808ab5acd1d2da6\",\"name\":\"Marius Sergent\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/301440054236d5b7095b58a39a352af54edf599e41a9bcafa831f3d696c92642?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/301440054236d5b7095b58a39a352af54edf599e41a9bcafa831f3d696c92642?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/301440054236d5b7095b58a39a352af54edf599e41a9bcafa831f3d696c92642?s=96&d=retro&r=g\",\"caption\":\"Marius Sergent\"},\"url\":\"https:\\\/\\\/www.mydral.com\\\/en\\\/author\\\/mariuss\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Les 3 Minutes Analytics : comment pivoter sa table dans KNIME?","description":"Vous \u00eates un KNIME Jedi et vous souhaitez aller plus loin ! Dans cet article, apprenez \u00e0 manipuler le node pivoting. Vous saurez cr\u00e9er vos TCD.","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\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/","og_locale":"en_GB","og_type":"article","og_title":"Les 3 Minutes Analytics : comment pivoter sa table dans KNIME?","og_description":"Vous \u00eates un KNIME Jedi et vous souhaitez aller plus loin ! Dans cet article, apprenez \u00e0 manipuler le node pivoting. Vous saurez cr\u00e9er vos TCD.","og_url":"https:\/\/www.mydral.com\/en\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/","og_site_name":"MYDRAL - DATA IS POWER","article_publisher":"https:\/\/www.facebook.com\/mydral\/?fref=ts","article_published_time":"2020-07-30T09:45:55+00:00","article_modified_time":"2026-08-24T14:45:12+00:00","og_image":[{"width":1288,"height":720,"url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN024-Pivoter.png","type":"image\/png"}],"author":"Marius Sergent","twitter_card":"summary_large_image","twitter_creator":"@MYDRAL_COM","twitter_site":"@MYDRAL_COM","twitter_misc":{"Written by":"Marius Sergent","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/#article","isPartOf":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/"},"author":{"name":"Marius Sergent","@id":"https:\/\/www.mydral.com\/#\/schema\/person\/aeefb62ec34427c9f808ab5acd1d2da6"},"headline":"Les 3 Minutes Analytics : comment pivoter sa table dans KNIME?","datePublished":"2020-07-30T09:45:55+00:00","dateModified":"2026-08-24T14:45:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/"},"wordCount":466,"commentCount":0,"publisher":{"@id":"https:\/\/www.mydral.com\/#organization"},"image":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN024-Pivoter.png","keywords":["Knime","node"],"articleSection":["La minute Analytics"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/","url":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/","name":"Les 3 Minutes Analytics : comment pivoter sa table dans KNIME?","isPartOf":{"@id":"https:\/\/www.mydral.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/#primaryimage"},"image":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN024-Pivoter.png","datePublished":"2020-07-30T09:45:55+00:00","dateModified":"2026-08-24T14:45:12+00:00","description":"Vous \u00eates un KNIME Jedi et vous souhaitez aller plus loin ! Dans cet article, apprenez \u00e0 manipuler le node pivoting. Vous saurez cr\u00e9er vos TCD.","breadcrumb":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/#primaryimage","url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN024-Pivoter.png","contentUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN024-Pivoter.png","width":1288,"height":720,"caption":"#KN024 Pivoter sa table dans KNIME"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-pivoter-sa-table-dans-knime\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.mydral.com\/"},{"@type":"ListItem","position":2,"name":"Les 3 Minutes Analytics : comment pivoter sa table dans 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\/aeefb62ec34427c9f808ab5acd1d2da6","name":"Marius Sergent","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/301440054236d5b7095b58a39a352af54edf599e41a9bcafa831f3d696c92642?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/301440054236d5b7095b58a39a352af54edf599e41a9bcafa831f3d696c92642?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/301440054236d5b7095b58a39a352af54edf599e41a9bcafa831f3d696c92642?s=96&d=retro&r=g","caption":"Marius Sergent"},"url":"https:\/\/www.mydral.com\/en\/author\/mariuss\/"}]}},"views":1804,"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/06\/KN024-Pivoter.png","_links":{"self":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/6171","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/comments?post=6171"}],"version-history":[{"count":10,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/6171\/revisions"}],"predecessor-version":[{"id":33677,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/6171\/revisions\/33677"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media\/7354"}],"wp:attachment":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media?parent=6171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/categories?post=6171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/tags?post=6171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}