{"id":192962,"date":"2023-03-28T07:29:00","date_gmt":"2023-03-28T07:29:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=192962"},"modified":"2023-11-09T13:30:22","modified_gmt":"2023-11-09T13:30:22","slug":"fonction-concatenate-power-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/fonction-concatenate-power-query","title":{"rendered":"Fonction CONTATENATE sur Power Query : Tutoriel complet"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"192962\" class=\"elementor elementor-192962\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c4c77bd e-flex e-con-boxed e-con\" data-id=\"c4c77bd\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-babc02d elementor-widget elementor-widget-heading\" data-id=\"babc02d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Si Power Query vous offre une multitude de fonctionnalit\u00e9s, certaines ne sont pas directement accessibles depuis son ruban. C\u2019est justement le cas de la fonction CONCATENATE qui permet de fusionner plusieurs colonnes. Alors comment utiliser CONCATENATE dans Power Query ? C\u2019est ce que nous allons voir dans cet article.<span style=\"color: var( --e-global-color-primary ); text-align: var(--text-align);\"><\/span><br><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-23dbd31 e-flex e-con-boxed e-con\" data-id=\"23dbd31\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4a83760 elementor-widget elementor-widget-heading\" data-id=\"4a83760\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Qu'est ce que la fonction CONCATENATE dans Power Query ?<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-01dfa52 elementor-widget elementor-widget-text-editor\" data-id=\"01dfa52\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>La fonction CONCATENATE\u00a0dans <a style=\"font-weight: 400;\" href=\"https:\/\/datascientest.com\/power-query-tout-savoir\">Power Query<\/a> <span style=\"font-weight: 400;\">permet de <\/span><b>fusionner des colonnes Texte et\/ou num\u00e9rique.<\/b><span style=\"font-weight: 400;\"> L\u2019un des exemples les plus courants, c\u2019est le nom de famille et le pr\u00e9nom.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Quelles que soient les colonnes \u00e0 fusionner, voici les \u00e9tapes \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">chargez les donn\u00e9es dans l\u2019\u00e9diteur de requ\u00eates en vous rendant dans l\u2019onglet \u00ab\u00a0Donn\u00e9es\u00a0\u00bb, puis s\u00e9lectionnez \u00ab\u00a0\u00e0 partir du tableau ou de la plage\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">v\u00e9rifiez les colonnes que vous souhaitez fusionner :\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquez sur \u00ab\u00a0Ajouter Colonne\u00a0\u00bb, puis sur \u00ab\u00a0Personnaliser les colonnes\u00a0\u00bb ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">pr\u00e9cisez le nom de la nouvelle colonne ;\u00a0<\/span><\/li><li aria-level=\"1\">dans la partie \u00ab\u00a0Formule de personnalisation de colonne\u00a0\u00bb, vous pouvez r\u00e9diger du langage M. C\u2019est-\u00e0-dire, utiliser la formule CONCATENATE\u00a0dans Power Query. Celle-ci se pr\u00e9sente sous la forme suivante =[colonne 1]&amp;\u201d \u201d&amp;[colonne 2] ;\u00a0<\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquez sur \u00ab\u00a0OK\u00a0\u00bb, \u00ab\u00a0Fermer\u00a0\u00bb et \u00ab\u00a0Appliquer\u00a0\u00bb<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d2f85f6 elementor-widget elementor-widget-text-editor\" data-id=\"d2f85f6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Vos deux colonnes ont fusionn\u00e9.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-97e40a1 elementor-widget__width-initial elementor-widget elementor-widget-code-highlight\" data-id=\"97e40a1\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-okaidia  \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup \">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>let  \r\n   Variablename = expression,  \r\n   #\"Variable name\" = expression2  \r\nin   \r\n   Variablename<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-384a10e e-flex e-con-boxed e-con\" data-id=\"384a10e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-509aef3 elementor-widget elementor-widget-heading\" data-id=\"509aef3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment utiliser la fonction \"Fusionner les colonnes\" dans Power Query ? <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-072180f elementor-widget elementor-widget-text-editor\" data-id=\"072180f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si vous ne souhaitez pas utiliser de formule, il est aussi possible de fusionner des colonnes en utilisant une fonction sp\u00e9cifique.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">L\u00e0 encore, la d\u00e9marche est tr\u00e8s simple :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">chargez les donn\u00e9es dans l\u2019\u00e9diteur de requ\u00eates en vous rendant dans l\u2019onglet \u00ab\u00a0Donn\u00e9es\u00a0\u00bb, puis s\u00e9lectionnez \u00ab\u00a0\u00e0 partir du tableau ou de la plage\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">s\u00e9lectionnez les colonnes que vous souhaitez fusionner ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquez sur \u00ab\u00a0Ajouter Colonne\u00a0\u00bb, puis sur \u00ab\u00a0Fusionner les colonnes\u00a0\u00bb<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">s\u00e9lectionnez le s\u00e9parateur dans la liste d\u00e9roulante. Vous pouvez choisir un espace, un tiret, une virgule\u2026 entre les deux jeux de donn\u00e9es ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">pr\u00e9cisez le nom de la nouvelle colonne ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquez sur \u00ab\u00a0OK\u00a0\u00bb.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-567af78 elementor-widget elementor-widget-text-editor\" data-id=\"567af78\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Une nouvelle colonne appara\u00eet alors sur votre \u00e9diteur de requ\u00eates.<\/span><\/p><p><span style=\"font-weight: 400;\"><strong>Bon \u00e0 savoir<\/strong> :<\/span><b> la fonction CONCATENATE\u00a0dans Power Query n\u2019\u00e9crase pas les colonnes existantes,<\/b><span style=\"font-weight: 400;\"> qui sont donc toujours pr\u00e9sentes dans votre tableau. Si, par exemple, il s\u2019agit du nom et du pr\u00e9nom, vous pourriez avoir 3 colonnes avec ces informations. Ce qui peut \u00eatre un peu redondant. Alors si vous souhaitez les supprimer, vous pouvez toujours utiliser les outils de transformation de l\u2019\u00e9diteur de requ\u00eates.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c8f547f elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"c8f547f\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Apprendre \u00e0 fusionner les colonnes dans Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4b555b4 e-flex e-con-boxed e-con\" data-id=\"4b555b4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1686bf1 elementor-widget elementor-widget-heading\" data-id=\"1686bf1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">La fonction \"Colonne \u00e0 partir d\u2019un exemple\"<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79fe5ea elementor-widget elementor-widget-text-editor\" data-id=\"79fe5ea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Vous pouvez concat\u00e9ner deux colonnes depuis Power Query en utilisant la fonction \u00ab\u00a0Colonne \u00e0 partir d\u2019un exemple\u00a0\u00bb.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">L\u2019id\u00e9e est alors de cr\u00e9er une nouvelle colonne dans une table existante en sp\u00e9cifiant un mod\u00e8le. Pour cela, deux options s\u2019offrent \u00e0 vous :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Depuis toutes les colonnes : Power Query identifie un mod\u00e8le pour toutes les colonnes du tableau.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Depuis une s\u00e9lection : Power Query identifie un mod\u00e8le uniquement pour les colonnes s\u00e9lectionn\u00e9es.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-641d007 elementor-widget elementor-widget-image\" data-id=\"641d007\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1108\" height=\"683\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/colonne-a-partir-dexemples-1.jpg\" class=\"attachment-full size-full wp-image-192965\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/colonne-a-partir-dexemples-1.jpg 1108w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/colonne-a-partir-dexemples-1-300x185.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/colonne-a-partir-dexemples-1-1024x631.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/colonne-a-partir-dexemples-1-768x473.jpg 768w\" sizes=\"(max-width: 1108px) 100vw, 1108px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f87061 elementor-widget elementor-widget-text-editor\" data-id=\"4f87061\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Quelle que soit l\u2019option choisie, la d\u00e9marche est la suivante :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">chargez les donn\u00e9es dans l\u2019\u00e9diteur de requ\u00eates en vous rendant dans l\u2019onglet \u00ab\u00a0Donn\u00e9es\u00a0\u00bb, puis s\u00e9lectionnez \u00ab\u00a0\u00e0 partir du tableau ou de la plage\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">s\u00e9lectionnez les colonnes que vous souhaitez fusionner :\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquez sur \u00ab\u00a0Ajouter Colonne\u00a0\u00bb, puis sur \u00ab\u00a0Colonne \u00e0 partir d\u2019exemple\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">cliquez sur la liste d\u00e9roulante et s\u00e9lectionnez \u00ab\u00a0\u00c0 partir de la s\u00e9lection\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">une colonne \u00ab\u00a0Fusion\u00a0\u00bb s\u2019affiche. Ici, vous devez \u00e9crire le r\u00e9sultat souhait\u00e9. Si le pr\u00e9nom est \u00ab\u00a0Marie\u00a0\u00bb et le nom de famille \u00ab\u00a0Dupond\u00a0\u00bb, vous pouvez, par exemple, \u00e9crire \u00ab\u00a0Marie Dupont\u00a0\u00bb, \u00ab\u00a0Marie.Dupond\u00a0\u00bb, \u00ab\u00a0Marie-Dupond\u00a0\u00bb\u2026 En fonction de l\u2019\u00e9criture apport\u00e9e, vous verrez que le langage M s\u2019\u00e9crit automatiquement en haut. Apr\u00e8s plusieurs tests, s\u00e9lectionnez l\u2019option qui vous convient ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">une fois que vous \u00eates satisfait de l&rsquo;aper\u00e7u de Power Query, cliquez sur \u00ab\u00a0Ok\u00a0\u00bb. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f28c4e2 elementor-widget elementor-widget-text-editor\" data-id=\"f28c4e2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Cette option vous permet d\u2019avoir un <\/span><b>r\u00e9sultat visuel rapidement <\/b><span style=\"font-weight: 400;\">pour vos colonnes. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7f95243 e-flex e-con-boxed e-con\" data-id=\"7f95243\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ca189f5 elementor-widget elementor-widget-heading\" data-id=\"ca189f5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">En conclusion <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a925641 elementor-widget elementor-widget-text-editor\" data-id=\"a925641\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Quelle que soit la m\u00e9thode utilis\u00e9e pour impl\u00e9menter <b style=\"font-weight: 400;\">la fonction <\/b><b>CONCATENATE<\/b><b style=\"font-weight: 400;\">\u00a0dans Power Query<\/b>, le r\u00e9sultat sera sensiblement le m\u00eame. Mais si vous ne connaissez pas les manipulations pr\u00e9sent\u00e9es ci-dessus, il sera difficile de fusionner des cellules. Et c\u2019est \u00e9galement le cas pour de nombreuses fonctionnalit\u00e9s de transformation. En effet, Power Query vous en propose plus de 300. Si vous souhaitez toutes les d\u00e9couvrir, mieux vaut vous former \u00e0 cet outil. Pour cela, <strong style=\"font-weight: 400;\">n\u2019h\u00e9sitez pas \u00e0 <\/strong><strong>suivre nos formations chez Datascientest<\/strong><span style=\"font-weight: 400;\">. Vous y apprendrez le traitement des donn\u00e9es, mais aussi l\u2019analyse, les pr\u00e9dictions, la mod\u00e9lisation, etc.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c03574 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"8c03574\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-excel\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir la formation  Excel <\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7461b4e e-flex e-con-boxed e-con\" data-id=\"7461b4e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b15cd5c elementor-widget elementor-widget-html\" data-id=\"b15cd5c\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est ce que la fonction CONCATENATE dans Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La fonction CONCATENATE dans Power Query permet de fusionner des colonnes Texte et\/ou num\u00e9rique. L\u2019un des exemples les plus courants, c\u2019est le nom de famille et le pr\u00e9nom.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"La fonction \"Colonne \u00e0 partir d\u2019un exemple\"\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Vous pouvez concat\u00e9ner deux colonnes depuis Power Query en utilisant la fonction \\\"Colonne \u00e0 partir d\u2019un exemple\\\". L\u2019id\u00e9e est alors de cr\u00e9er une nouvelle colonne dans une table existante en sp\u00e9cifiant un mod\u00e8le. Pour cela, deux options s\u2019offrent \u00e0 vous : Depuis toutes les colonnes : Power Query identifie un mod\u00e8le pour toutes les colonnes du tableau. Depuis une s\u00e9lection : Power Query identifie un mod\u00e8le uniquement pour les colonnes s\u00e9lectionn\u00e9es.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Si Power Query vous offre une multitude de fonctionnalit\u00e9s, certaines ne sont pas directement accessibles depuis son ruban. C\u2019est justement le cas de la fonction CONCATENATE qui permet de fusionner plusieurs colonnes. Alors comment utiliser CONCATENATE dans Power Query ? C\u2019est ce que nous allons voir dans cet article. Qu&rsquo;est ce que la fonction CONCATENATE [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":192964,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction CONTATENATE sur Power Query : Tutoriel complet<\/title>\n<meta name=\"description\" content=\"Vous d\u00e9sirez utiliser la fonction CONCATENATE de Power Query ? D\u00e9couvrez dans ce tutoriel trois m\u00e9thodes vous permettant de le faire.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/fonction-concatenate-power-query\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CONTATENATE sur Power Query : Tutoriel complet\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/fonction-concatenate-power-query\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-28T07:29:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:30:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fonction-concatenate-power-query.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/fonction-concatenate-power-query\",\"url\":\"https:\/\/datascientest.com\/fonction-concatenate-power-query\",\"name\":\"Fonction CONTATENATE sur Power Query : Tutoriel complet\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-03-28T07:29:00+00:00\",\"dateModified\":\"2023-11-09T13:30:22+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Vous d\u00e9sirez utiliser la fonction CONCATENATE de Power Query ? D\u00e9couvrez dans ce tutoriel trois m\u00e9thodes vous permettant de le faire.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/fonction-concatenate-power-query\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Fonction CONTATENATE sur Power Query : Tutoriel complet","description":"Vous d\u00e9sirez utiliser la fonction CONCATENATE de Power Query ? D\u00e9couvrez dans ce tutoriel trois m\u00e9thodes vous permettant de le faire.","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:\/\/datascientest.com\/fonction-concatenate-power-query","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CONTATENATE sur Power Query : Tutoriel complet","og_url":"https:\/\/datascientest.com\/fonction-concatenate-power-query","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-03-28T07:29:00+00:00","article_modified_time":"2023-11-09T13:30:22+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fonction-concatenate-power-query.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/fonction-concatenate-power-query","url":"https:\/\/datascientest.com\/fonction-concatenate-power-query","name":"Fonction CONTATENATE sur Power Query : Tutoriel complet","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-03-28T07:29:00+00:00","dateModified":"2023-11-09T13:30:22+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Vous d\u00e9sirez utiliser la fonction CONCATENATE de Power Query ? D\u00e9couvrez dans ce tutoriel trois m\u00e9thodes vous permettant de le faire.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/fonction-concatenate-power-query"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/192962"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=192962"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/192962\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/192964"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=192962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=192962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=192962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}