{"id":2119,"date":"2026-10-28T12:52:14","date_gmt":"2026-10-28T11:52:14","guid":{"rendered":"https:\/\/declick.be\/?page_id=2119"},"modified":"2026-10-28T14:05:42","modified_gmt":"2026-10-28T13:05:42","slug":"formation-power-query-lbw","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/formation-power-query-lbw\/","title":{"rendered":"Formation Power Query LBW"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Ci-dessous, vous trouverez diff\u00e9rents fichiers de travail sur la r\u00e9cup\u00e9ration de donn\u00e9es au sein de LBW<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/LBW-Exercice-1-consommations-compteurs.xlsx\">Exercice 1<\/a> : Fichier par lequel seront r\u00e9alis\u00e9es 2 t\u00e2ches :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1- cr\u00e9er une liste des renseignements utiles sur les compteurs des logements<\/li>\n\n\n\n<li>2 &#8211; r\u00e9cup\u00e9ration des consommations correspondant \u00e0 des dates et des logements pr\u00e9cis, avec r\u00e9organisation de la structure du fichier<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/LBW-Exercice-2.xlsx\">Exercice 2<\/a> : Fichier qui combine plusieurs fichiers d&rsquo;un dossier<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fichiers de donn\u00e9es \u00e0 t\u00e9l\u00e9charger : <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/Gestionnaire1.xlsx\">Fic1 <\/a>&#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/Gestionnaire2.xlsx\">Fic2 <\/a>&#8211; <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/Gestionnaire3.xlsx\">Fic3<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/LBW-Exercice-3.xlsx\">Exercice 3<\/a> : Fichier qui combine plusieurs fichiers d&rsquo;un dossier, le dernier fichier d&rsquo;un dossier, &#8230; r\u00e9solution de probl\u00e8mes de combinaison de fichiers<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fichiers de donn\u00e9es \u00e0 t\u00e9l\u00e9charger :\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/Exemple-3-012-RUE-HAUTE-369.xls\">Exemple-3-012-RUE-HAUTE-369.xls<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/Exemple-3-011-RUE-DU-MEIBOOM-24.xls\">Exemple-3-011-RUE-DU-MEIBOOM-24.xls<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/Exemple-3-010-RUE-DES-TANNEURS-115.xlsx\">Exemple-3-010-RUE-DES-TANNEURS-115.xlsx<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2026\/10\/Exemple-3-010-PLACE-DE-LA-QUERELLE-10-14.xlsx\">Exemple-3-010-PLACE-DE-LA-QUERELLE-10-14.xlsx<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Ci-dessous, vous trouverez diff\u00e9rents fichiers de travail sur la r\u00e9cup\u00e9ration de donn\u00e9es au sein de LBW Exercice 1 : Fichier par lequel seront r\u00e9alis\u00e9es 2 t\u00e2ches : Exercice 2 : Fichier qui combine plusieurs&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2119","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/2119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/comments?post=2119"}],"version-history":[{"count":4,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/2119\/revisions"}],"predecessor-version":[{"id":2138,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/2119\/revisions\/2138"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=2119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}