{"id":6095,"date":"2020-07-29T10:05:49","date_gmt":"2020-07-29T08:05:49","guid":{"rendered":"https:\/\/www.mydral.com\/?p=6095"},"modified":"2020-07-29T16:18:40","modified_gmt":"2020-07-29T14:18:40","slug":"les-3-minutes-analytics-comment-creer-un-group-by-dans-knime","status":"publish","type":"post","link":"https:\/\/www.mydral.com\/en\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/","title":{"rendered":"Les 3 minutes Analytics : Comment cr\u00e9er un Group By dans KNIME ?"},"content":{"rendered":"<p>Bonjours \u00e0 tous ! Pr\u00eat \u00e0 suivre notre nouvel article de notre s\u00e9rie Les 3 Minutes Analytics KNIME ? C\u2019est parti ! A la fin de ce tutoriel, vous saurez manipuler le Group By. En effet, l\u2019objectif de ce tutoriel est de vous aider \u00e0 comprendre comment manipuler ce node<strong> GroupBy<\/strong> dans KNIME.<\/p>\n<p>Pour rappel, vous suivez le parcours 2. Les diff\u00e9rents modules du<strong> parcours 1<\/strong> vous ont permis de devenir un KNIME beginner<em>\u00a0<\/em>avec les fonctionnalit\u00e9s de base. Place au <strong>parcours 2<\/strong> pour devenir un KNIME rookie.<\/p>\n<p><strong><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;\" \/> Mydral vous propose \u00e9galement de d\u00e9couvrir en vid\u00e9o ce tutoriel :<\/strong><\/p>\n<div class=\"embed-responsive embed-responsive-16by9\"><iframe loading=\"lazy\" title=\"KN0014 - Aggregation GroupBy\" src=\"https:\/\/player.vimeo.com\/video\/441976361?h=b879b29ef6&amp;dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write\"><\/iframe><\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Dans illustrer mon tutoriel, j\u2019utilise un fichier CSV qui concerne les commandes d&rsquo;une entreprise appel\u00e9e Sport Up, et le node <strong>GroupBy<\/strong>. L\u2019objectif de cet exemple est de connaitre le client qui commande le plus de fois et le nombre de clients uniques par territoire.<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #ff6600;\">Etape 1 : Le Node GroupBy<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>Je remarque que sous mon node <strong>GroupBy<\/strong>, il y a un message d\u2019alerte.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6091 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img0.png\" alt=\"Node GroupBy KNIME\" width=\"763\" height=\"476\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img0.png 763w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img0-300x187.png 300w\" sizes=\"auto, (max-width: 763px) 100vw, 763px\" \/><\/p>\n<p>Ce message\u00a0 m\u2019informe qu\u2019il doit \u00eatre configur\u00e9. Clic droit -&gt; Configure.<\/p>\n<p>Lors de l\u2019ouverture du panneau de configuration, celui-ci se divise en deux parties.<\/p>\n<p>La premi\u00e8re partie affiche les onglets et deux colonnes. La colonne de gauche donne la liste de vos colonnes que vous pouvez glisser dans la colonne de droite pour les grouper. Ici, la colonne <strong>Territory Name<\/strong> est la colonne qui va \u00eatre group\u00e9e.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6093 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img2.png\" alt=\"GroupBy Node KNIME\" width=\"688\" height=\"400\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img2.png 688w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img2-300x174.png 300w\" sizes=\"auto, (max-width: 688px) 100vw, 688px\" \/><\/p>\n<h2><\/h2>\n<h2><span style=\"color: #ff6600;\">Etape 2 : les param\u00e8tres avanc\u00e9s du node GroupBy<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>La seconde partie concerne les param\u00e8tres avanc\u00e9s tels que :<\/p>\n<p>&#8211; <strong>Colunm Naming<\/strong> : choix du nom des colonnes qui seront agr\u00e9g\u00e9es<\/p>\n<p>&#8211; <strong>Enable Hiligting<\/strong> : pour mettre en lumi\u00e8re vos colonnes<\/p>\n<p>&#8211; <strong>Process in memory<\/strong> : donne une meilleure performance sur les petits jeux de donn\u00e9e<\/p>\n<p>&#8211; <strong>Retain row order<\/strong> : garde l\u2019ordre du jeu de donn\u00e9e<\/p>\n<p>&#8211; <strong>Maximum unique values per group<\/strong> : \u00e9vite la surcharge de m\u00e9moire<\/p>\n<p>&#8211; <strong>Value delimiter<\/strong> : est la valeur qui d\u00e9limite<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6096 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img3.png\" alt=\"Node GroupBy KNIME\" width=\"686\" height=\"87\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img3.png 686w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img3-300x38.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Dans cet exemple, je n\u2019ai rien chang\u00e9 aux param\u00e8tres avanc\u00e9s.<\/p>\n<p>Ensuite, il y a trois possibilit\u00e9s d\u2019agr\u00e9ger des valeurs, <strong>manuellement<\/strong> comme dans cet exemple, par pattern ou par<strong> type<\/strong>.<\/p>\n<p>Sur l\u2019onglet <strong>Manual Aggregation<\/strong>, je vais choisir <strong>Customer ID<\/strong> deux fois, chaque ligne va avoir une agr\u00e9gation.<\/p>\n<p>La premi\u00e8re ligne sera avec <strong>Mode<\/strong> pour m&rsquo;indiquer le client qui a pass\u00e9 le plus de commandes par territoire et la seconde ligne est <strong>Unique count<\/strong> afin de connaitre le nombre unique de clients par territoire.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6097 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img4.png\" alt=\"Manipuler un node GroupBy KNIME\" width=\"700\" height=\"592\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img4.png 700w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img4-300x254.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Selon certaines agr\u00e9gations il est possible d\u2019inclure les valeurs manquantes en cochant la case \u00e0 droite de l\u2019agr\u00e9gation choisie.<\/p>\n<p>Pour choisir l\u2019agr\u00e9gation de Customer ID, je dois d\u00e9rouler le menu avec un clic comme dans l&rsquo;exemple ci-dessous :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6098 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img5.png\" alt=\"Node GroupBy KNIME \" width=\"455\" height=\"190\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img5.png 455w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img5-300x125.png 300w\" sizes=\"auto, (max-width: 455px) 100vw, 455px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Il est possible de chercher des informations sur une agr\u00e9gation, vous trouverez son descriptif dans l\u2019onglet <strong>Description<\/strong> en haut \u00e0 c\u00f4t\u00e9 de l\u2019onglet <strong>Settings<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6099 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img6.png\" alt=\"Node GroupBy KNIME \" width=\"714\" height=\"610\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img6.png 714w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img6-300x256.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Une fois la configuration termin\u00e9e, je l\u2019ex\u00e9cute et demande \u00e0 voir son r\u00e9sultat avec <strong>Group Table<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #ff6600;\">Etape finale ! Voici le r\u00e9sultat :<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6100 size-full\" src=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img7.png\" alt=\"Node GroupBy KNIME\" width=\"648\" height=\"240\" srcset=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img7.png 648w, https:\/\/www.mydral.com\/wp-content\/uploads\/2019\/01\/gpby_img7-300x111.png 300w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/p>\n<p>En Australie le client qui passe le plus de commande est le num\u00e9ro 29488 et il y a 3625 clients uniques.<\/p>\n<p>Merci d\u2019avoir suivi cet article, j\u2019esp\u00e8re qu\u2019il vous a \u00e9t\u00e9 utile. Pour rappel, les <span style=\"color: #ff6600;\"><a style=\"color: #ff6600;\" href=\"https:\/\/www.mydral.com\/en\/category\/les-3-minutes-analytics\/\">3 Minutes Analytics<\/a> <\/span>sont une s\u00e9rie de parcours et de diff\u00e9rents modules pour ma\u00eetriser les fonctions principales de la solution KNIME.<\/p>\n<p>Votre avis nous int\u00e9resse ! Quatre parcours de KNIME Beginner \u00e0 KNIME expert vous attendent. Parlez-nous de votre parcours KNIME en commentaires !<\/p>\n<p>Suivez-nous sur les r\u00e9seaux sociaux :<span style=\"color: #ff6600;\"><a style=\"color: #ff6600;\" href=\"https:\/\/www.linkedin.com\/company\/mydral\/\"> LinkedIn<\/a> <\/span>&amp; <span style=\"color: #ff6600;\"><a style=\"color: #ff6600;\" href=\"https:\/\/twitter.com\/MYDRAL_COM\">Twitter<\/a> <\/span>!<\/p>","protected":false},"excerpt":{"rendered":"Dans ce module de votre parcours KNIME, vous allez apprendre \u00e0 manipuler le node GroupBy dans KNIME. Testez-le d\u00e8s \u00e0 pr\u00e9sent !","protected":false},"author":6,"featured_media":7316,"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-6095","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 cr\u00e9er un Group By dans KNIME ?<\/title>\n<meta name=\"description\" content=\"Dans ce module de votre parcours KNIME, vous allez apprendre \u00e0 manipuler le node GroupBy dans KNIME. Testez-le d\u00e8s \u00e0 pr\u00e9sent !\" \/>\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-creer-un-group-by-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 cr\u00e9er un Group By dans KNIME ?\" \/>\n<meta property=\"og:description\" content=\"Dans ce module de votre parcours KNIME, vous allez apprendre \u00e0 manipuler le node GroupBy dans KNIME. Testez-le d\u00e8s \u00e0 pr\u00e9sent !\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mydral.com\/en\/les-3-minutes-analytics-comment-creer-un-group-by-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-29T08:05:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-29T14:18:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/07\/GroupBy2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1284\" \/>\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=\"3 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-creer-un-group-by-dans-knime\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/\"},\"author\":{\"name\":\"Marius Sergent\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/person\\\/aeefb62ec34427c9f808ab5acd1d2da6\"},\"headline\":\"Les 3 minutes Analytics : Comment cr\u00e9er un Group By dans KNIME ?\",\"datePublished\":\"2020-07-29T08:05:49+00:00\",\"dateModified\":\"2020-07-29T14:18:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/\"},\"wordCount\":637,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/GroupBy2.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-creer-un-group-by-dans-knime\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/\",\"name\":\"Les 3 minutes Analytics : Comment cr\u00e9er un Group By dans KNIME ?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/GroupBy2.png\",\"datePublished\":\"2020-07-29T08:05:49+00:00\",\"dateModified\":\"2020-07-29T14:18:40+00:00\",\"description\":\"Dans ce module de votre parcours KNIME, vous allez apprendre \u00e0 manipuler le node GroupBy dans KNIME. Testez-le d\u00e8s \u00e0 pr\u00e9sent !\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/GroupBy2.png\",\"contentUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/GroupBy2.png\",\"width\":1284,\"height\":720,\"caption\":\"#KN014 GroupBy KNIME\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/les-3-minutes-analytics-comment-creer-un-group-by-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 cr\u00e9er un Group By 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 cr\u00e9er un Group By dans KNIME ?","description":"Dans ce module de votre parcours KNIME, vous allez apprendre \u00e0 manipuler le node GroupBy dans KNIME. Testez-le d\u00e8s \u00e0 pr\u00e9sent !","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-creer-un-group-by-dans-knime\/","og_locale":"en_GB","og_type":"article","og_title":"Les 3 minutes Analytics : Comment cr\u00e9er un Group By dans KNIME ?","og_description":"Dans ce module de votre parcours KNIME, vous allez apprendre \u00e0 manipuler le node GroupBy dans KNIME. Testez-le d\u00e8s \u00e0 pr\u00e9sent !","og_url":"https:\/\/www.mydral.com\/en\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/","og_site_name":"MYDRAL - DATA IS POWER","article_publisher":"https:\/\/www.facebook.com\/mydral\/?fref=ts","article_published_time":"2020-07-29T08:05:49+00:00","article_modified_time":"2020-07-29T14:18:40+00:00","og_image":[{"width":1284,"height":720,"url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/07\/GroupBy2.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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/#article","isPartOf":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/"},"author":{"name":"Marius Sergent","@id":"https:\/\/www.mydral.com\/#\/schema\/person\/aeefb62ec34427c9f808ab5acd1d2da6"},"headline":"Les 3 minutes Analytics : Comment cr\u00e9er un Group By dans KNIME ?","datePublished":"2020-07-29T08:05:49+00:00","dateModified":"2020-07-29T14:18:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/"},"wordCount":637,"commentCount":0,"publisher":{"@id":"https:\/\/www.mydral.com\/#organization"},"image":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/07\/GroupBy2.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-creer-un-group-by-dans-knime\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/","url":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/","name":"Les 3 minutes Analytics : Comment cr\u00e9er un Group By dans KNIME ?","isPartOf":{"@id":"https:\/\/www.mydral.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/#primaryimage"},"image":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/07\/GroupBy2.png","datePublished":"2020-07-29T08:05:49+00:00","dateModified":"2020-07-29T14:18:40+00:00","description":"Dans ce module de votre parcours KNIME, vous allez apprendre \u00e0 manipuler le node GroupBy dans KNIME. Testez-le d\u00e8s \u00e0 pr\u00e9sent !","breadcrumb":{"@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-dans-knime\/#primaryimage","url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/07\/GroupBy2.png","contentUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/07\/GroupBy2.png","width":1284,"height":720,"caption":"#KN014 GroupBy KNIME"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mydral.com\/les-3-minutes-analytics-comment-creer-un-group-by-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 cr\u00e9er un Group By 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":1909,"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2020\/07\/GroupBy2.png","_links":{"self":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/6095","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=6095"}],"version-history":[{"count":7,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/6095\/revisions"}],"predecessor-version":[{"id":7315,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/6095\/revisions\/7315"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media\/7316"}],"wp:attachment":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media?parent=6095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/categories?post=6095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/tags?post=6095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}