{"id":1975,"date":"2022-07-26T08:17:04","date_gmt":"2022-07-26T08:17:04","guid":{"rendered":"https:\/\/exceltic.com\/?p=1975"},"modified":"2022-10-27T07:05:37","modified_gmt":"2022-10-27T07:05:37","slug":"creation-and-automation-of-an-etl-convert-xml-to-a-relational-dataset","status":"publish","type":"post","link":"https:\/\/exceltic.serquo.com\/en\/creation-and-automation-of-an-etl-convert-xml-to-a-relational-dataset\/","title":{"rendered":"ETL with Alteryx: Converting XML to a relational dataset"},"content":{"rendered":"<p>Every day, <strong>companies accumulate more and more documentation,<\/strong> due to the increase in the number of processes that can be managed from an IT system. Thus, there is an even greater decentralisation of data-driven decision-making.<\/p>\n\n\n\n<p>According to studies, 92% of companies invest in storage, analytics and artificial intelligence to leverage their information. However, only 19% believe that they make the right strategic, data-driven decisions (<strong>Data Driven companies<\/strong>).<\/p>\n\n\n\n<p><strong>The problem<\/strong>, in many cases, lies in the <strong>diverse provenance of the data<\/strong>. Data is collected from different sources, be it from a production and warehousing system, from different sales departments, or even from different finance and human resources departments. <\/p>\n\n\n\n<p>In addition, not all data are in the same format (XML, JSON, XLS...), which makes it even more difficult to compare them. Thus, the need to create ETLs arises.<\/p>\n\n\n\n<p class=\"has-primary-color has-text-color has-large-font-size\">WHAT IS AN ETL?<\/p>\n\n\n\n<p>An <strong>ETL<\/strong>(Extract, Transform, Load) is a tool capable of <strong>centralising<\/strong> information, <strong>extracting<\/strong> it from different sources, <strong>transforming <\/strong>all the desired criteria for better understanding or eliminating errors and then loading it into a destination data warehouse.&nbsp;<\/p>\n\n\n\n<p>These data movements can be programmed on a regular basis or activated to occur periodically. The types of projects for which ETL tools are used vary widely, as these tools are designed to be very flexible.&nbsp;<\/p>\n\n\n\n<p><strong>Some common projects would be:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Migration of application data from old to new systems<\/li><li><a href=\"https:\/\/exceltic.com\/integridad-de-datos\/\">Data integration<\/a> of recent corporate mergers and acquisitions<\/li><li>Integration of data from external suppliers and partners<\/li><li>Collection of transactional data for business people to work with, commonly referred to as Data Marts or Data Warehouses.<\/li><\/ul>\n\n\n\n<p>Once an organisation opts for ETL, the company is \"married\" to that specific tool, as it will design a lot of logic into the data movement processes and become a vital part of managing its business. Therefore, <strong>the purchase and use of an ETL tool is a very strategic move<\/strong>, even if it is intended for a small tactical project to begin with. <\/p>\n\n\n\n<p class=\"has-primary-color has-text-color has-large-font-size\">WHAT ARE THE PHASES OF AN ETL?<\/p>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-secondary-color\">Extraction Phase:<\/mark><\/p>\n\n\n\n<p>Most companies have numerous data sources and use a myriad of analytical tools to produce business intelligence. Extraction consists of <strong>bringing \"raw\" data from different sources and transferring it to a single repository.<\/strong>. <\/p>\n\n\n\n<p><strong>Examples of data sources include:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Legacy systems<\/li><li>Relational databases<\/li><li>XML files<\/li><li>CRM systems<\/li><li>XLS files<\/li><li>Business applications<\/li><li>Analytics tools<\/li><li>JSON<\/li><\/ul>\n\n\n\n<p>Having different data sources represents a major challenge for organisations, as storing different types of information significantly increases data governance and storage costs. <\/p>\n\n\n\n<p>Additionally, there are ecosystems that are not natively compatible with other solutions, which makes it even more difficult to weave information from different sources and in different formats together. <\/p>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-secondary-color\">Transformation Phase: <\/mark><\/p>\n\n\n\n<p>The cleaning and organisation stage is the stage where all data from multiple source systems<strong> are standardised and converted into a convenient format<\/strong>, which improves their quality, governance and exploitation. During this stage, data can undergo various operations: cleansing, filtering, decoupling, merging, reorganisation, duplication.....<\/p>\n\n\n\n<p>Some of the <strong>main advantages<\/strong> of automatic transformation over manual transformation is to ensure that global changes are made to datasets in a systematic way, e.g. special characters can be removed and the layout of data can be completely changed once the data transformation process is completed, duplicate items can be removed, field formatting can be changed, blank or redundant rows and columns can be removed, and only data that is interesting to store for later exploitation can be kept.&nbsp;<\/p>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-secondary-color\">Charging phase:<\/mark><\/p>\n\n\n\n<p>After having this new view, with a new perspective, <strong>the newly selected data must be loaded into a data warehouse.<\/strong>Loading a large amount of data into a data warehouse, for example, makes it easier to access and use the information, regardless of how many different types of data have gone through the ETL process.<\/p>\n\n\n\n<p>The result is a clean set of data, structured and correctly classified, that is ready to be used, which will help organisations make critical business decisions and perform further analysis effectively.<\/p>\n\n\n\n<p class=\"has-primary-color has-text-color has-large-font-size\">WHAT ARE THE ADVANTAGES OF AN ETL?<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Enables a common data repository<\/li><li>Improves decision making<\/li><li>Enables comparison of sample data between source and target system&nbsp;<\/li><li>Helps improve productivity by coding and reusing without the need for additional technical expertise. ETL provides deep historical context for the business<\/li><li>Helps identify meaningful patterns and insights<\/li><li>Converts disparate data into a consistent format<\/li><li>Helps derive business intelligence from the data&nbsp;<\/li><li>Contains easily usable components&nbsp;<\/li><li>Effortlessly manages complex transformation&nbsp;<\/li><li>Delivers maximum return on investment, i.e. roi<\/li><\/ol>\n\n\n\n<p>Although<strong> these tools can be programmed with any language <\/strong>(Java, C, C++, PHP...) they are mainly programmed in Python due to the large number of existing libraries, and are usually run with Apache Spark and PySpark.&nbsp;<\/p>\n\n\n\n<p class=\"has-primary-color has-text-color has-large-font-size\">ALTERYX tool<\/p>\n\n\n\n<p>However, <strong>there is an important gap between programmers and data analysts<\/strong>, since the former have the technical knowledge to carry it out, and the latter are the ones who must \"play\" with the data to reach valid conclusions for business development. This means a coordination and efficiency loss worth millions of \u20ac per year that you can calculate thanks to the <a href=\"https:\/\/www.alteryx.com\/es-419\/roi-calculator?utm_source=partner_generated&amp;utm_medium=pn_exceltic_sociedad_limitada&amp;prid=0032R00002Jqz0KQAR&amp;crp=0032R00002Jqz0KQAR&amp;apid=0012R00002DxPTcQAN\">Alteryx APA Platform\u2122.<\/a>.<\/p>\n\n\n\n<p>This is why in recent years, <strong>low-code<\/strong> tools have emerged that have revolutionised ETL processes, giving end users (data analysts) the power to perform their own extractions, transformations and data loading for subsequent analysis.&nbsp;<\/p>\n\n\n\n<p>These tools go further, giving the possibility to apply different modules that allow the analysis through Artificial Intelligence (machine and Deep learning) and obtain the conclusions.<\/p>\n\n\n\n<p>In this video we show how in less than 5 minutes we create an ETL for the extraction of an XML dataset and subsequent transformation and loading to a relational database with our <strong><a href=\"https:\/\/www.alteryx.com\/es-419\">ALTERYX tool<\/a><\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Alteryx ETL Introduction: How to transform an XML file into a dataset with relational structure\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/odptsREQmtA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><strong>Alteryx facilitates disparate data access, analytics and data science through a code-free, code-friendly platform<\/strong> It empowers business analysts to automate their entire analytics and process flows in the context of the desired business outcome.<\/p>\n\n\n\n<p>The platform has an intuitive drag-and-drop interface that allows for connectivity with different sources of information and its subsequent transformation and analysis.&nbsp;<\/p>\n\n\n\n<p><strong>Alteryx is present in all areas of the company:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes has-small-font-size\"><table style=\"border-style:none;border-width:0px\"><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">HR<\/th><th class=\"has-text-align-center\" data-align=\"center\">FINANCE<\/th><th class=\"has-text-align-center\" data-align=\"center\">MARKETING &amp; SALES<\/th><th class=\"has-text-align-center\" data-align=\"center\">OPERATIONS<\/th><th class=\"has-text-align-center\" data-align=\"center\">SUPPLY CHAIN<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">Employee retention<\/td><td class=\"has-text-align-center\" data-align=\"center\">Tax automation<\/td><td class=\"has-text-align-center\" data-align=\"center\">Segmentation<\/td><td class=\"has-text-align-center\" data-align=\"center\">Incident management<\/td><td class=\"has-text-align-center\" data-align=\"center\">Demand forecasting<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">EGS<\/td><td class=\"has-text-align-center\" data-align=\"center\">Audit and compliance<\/td><td class=\"has-text-align-center\" data-align=\"center\">Forecast<\/td><td class=\"has-text-align-center\" data-align=\"center\">Response time analysis<\/td><td class=\"has-text-align-center\" data-align=\"center\">Inventory optimisation<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Recruitment<\/td><td class=\"has-text-align-center\" data-align=\"center\">Daily reconciliation<\/td><td class=\"has-text-align-center\" data-align=\"center\">360 Clients<\/td><td class=\"has-text-align-center\" data-align=\"center\">Call centre analysis<\/td><td class=\"has-text-align-center\" data-align=\"center\">Predictive maintenance<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Performance<\/td><td class=\"has-text-align-center\" data-align=\"center\">Financial planning and analysis<\/td><td class=\"has-text-align-center\" data-align=\"center\">Rotation<\/td><td class=\"has-text-align-center\" data-align=\"center\">Customer sentiment<\/td><td class=\"has-text-align-center\" data-align=\"center\">Capacity planning<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Management<\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-32654c7a wp-block-columns-is-layout-flex\" style=\"padding-top:50px;padding-bottom:5px\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\" id=\"beneficios\">DO YOU WANT TO KNOW MORE?<\/h2>\n\n\n<div class=\"wpforms-container wpforms-container-full wpforms-block contact-us\" id=\"wpforms-1165\"><form id=\"wpforms-form-1165\" class=\"wpforms-validate wpforms-form wpforms-ajax-form\" data-formid=\"1165\" method=\"post\" enctype=\"multipart\/form-data\" action=\"\/en\/wp-json\/wp\/v2\/posts\/1975\" data-token=\"d270138a0ba7e637dda55c9808ef9304\" data-token-time=\"1776239656\" data-trp-original-action=\"\/en\/wp-json\/wp\/v2\/posts\/1975\"><noscript class=\"wpforms-error-noscript\">Please enable JavaScript in your browser to complete this form.<\/noscript><div class=\"wpforms-field-container\"><div id=\"wpforms-1165-field_1-container\" class=\"wpforms-field wpforms-field-email\" data-field-id=\"1\"><label class=\"wpforms-field-label wpforms-label-hide\" for=\"wpforms-1165-field_1\">Email <span class=\"wpforms-required-label\">*<\/span><\/label><input type=\"email\" id=\"wpforms-1165-field_1\" class=\"wpforms-field-large wpforms-field-required\" name=\"wpforms[fields][1]\" placeholder=\"E-mail\" spellcheck=\"false\" required><\/div><div id=\"wpforms-1165-field_5-container\" class=\"wpforms-field wpforms-field-text\" data-field-id=\"5\"><label class=\"wpforms-field-label wpforms-label-hide\" for=\"wpforms-1165-field_5\">Subject <span class=\"wpforms-required-label\">*<\/span><\/label><input type=\"text\" id=\"wpforms-1165-field_5\" class=\"wpforms-field-large wpforms-field-required\" name=\"wpforms[fields][5]\" placeholder=\"Subject\" required><\/div><div id=\"wpforms-1165-field_2-container\" class=\"wpforms-field wpforms-field-textarea\" data-field-id=\"2\"><label class=\"wpforms-field-label wpforms-label-hide\" for=\"wpforms-1165-field_2\">Message<\/label><textarea id=\"wpforms-1165-field_2\" class=\"wpforms-field-medium\" name=\"wpforms[fields][2]\" placeholder=\"Message\" ><\/textarea><\/div><div id=\"wpforms-1165-field_6-container\" class=\"wpforms-field wpforms-field-checkbox boxtransparent\" data-field-id=\"6\"><ul id=\"wpforms-1165-field_6\" class=\"wpforms-field-required\"><li class=\"choice-1 depth-1\"><input type=\"checkbox\" id=\"wpforms-1165-field_6_1\" name=\"wpforms[fields][6][]\" value=\" He le\u00eddo y acepto la pol\u00edtica de privacidad\" required><label class=\"wpforms-field-label-inline\" for=\"wpforms-1165-field_6_1\">I have read and accept the privacy policy <span class=\"wpforms-required-label\">*<\/span><\/label><\/li><\/ul><div class=\"wpforms-field-description wpforms-disclaimer-description\"><b>IMPORTANT:<\/b> Read our <a href='https:\/\/exceltic.com\/politica-de-privacidad\/' target='_blank' style=\"color: #e74b10;\" >Privacy Policy<\/a> before proceeding. The information you provide may contain personal information.<\/div><\/div><\/div><!-- .wpforms-field-container --><div class=\"wpforms-recaptcha-container wpforms-is-recaptcha wpforms-is-recaptcha-type-v2\" ><div class=\"g-recaptcha\" data-sitekey=\"6Lf9t3srAAAAAEstc-76vP4_LAvjdEbLQwgAri5D\"><\/div><input type=\"text\" name=\"g-recaptcha-hidden\" class=\"wpforms-recaptcha-hidden\" style=\"position:absolute!important;clip:rect(0,0,0,0)!important;height:1px!important;width:1px!important;border:0!important;overflow:hidden!important;padding:0!important;margin:0!important;\" data-rule-recaptcha=\"1\"><\/div><div class=\"wpforms-submit-container\" ><input type=\"hidden\" name=\"wpforms[id]\" value=\"1165\"><input type=\"hidden\" name=\"page_title\" value=\"\"><input type=\"hidden\" name=\"page_url\" value=\"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/posts\/1975\"><input type=\"hidden\" name=\"url_referer\" value=\"\"><button type=\"submit\" name=\"wpforms[submit]\" id=\"wpforms-submit-1165\" class=\"wpforms-submit submit-button\" data-alt-text=\"Enviando...\" data-submit-text=\"Enviar\" aria-live=\"assertive\" value=\"wpforms-submit\">Send<\/button><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceltic.serquo.com\/wp-content\/plugins\/wpforms-lite\/assets\/images\/submit-spin.svg\" class=\"wpforms-submit-spinner\" style=\"display: none;\" width=\"26\" height=\"26\" alt=\"Loading\"><\/div><input type=\"hidden\" name=\"trp-form-language\" value=\"en\"\/><\/form><\/div>  <!-- .wpforms-container -->","protected":false},"excerpt":{"rendered":"<p>Extraction from various data sources using our Alteryx tool, transformation of an XML file and automatic loading of the data for easy manipulation.<\/p>","protected":false},"author":1,"featured_media":2008,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1975","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-partners"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ETL con Alteryx: Convertir XML a un set de datos relacionales<\/title>\n<meta name=\"description\" content=\"ETL en Alteryx de un archivo XML, convirti\u00e9ndolo en un set de datos relacional, para facilitar su posterior consumo\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceltic.serquo.com\/en\/creation-and-automation-of-an-etl-convert-xml-to-a-relational-dataset\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ETL con Alteryx: Convertir XML a un set de datos relacionales\" \/>\n<meta property=\"og:description\" content=\"ETL en Alteryx de un archivo XML, convirti\u00e9ndolo en un set de datos relacional, para facilitar su posterior consumo\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceltic.serquo.com\/en\/creation-and-automation-of-an-etl-convert-xml-to-a-relational-dataset\/\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/exceltic\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-26T08:17:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-27T07:05:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1449\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Serquo Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@exceltic\" \/>\n<meta name=\"twitter:site\" content=\"@exceltic\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Serquo Admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/\"},\"author\":{\"name\":\"Serquo Admin\",\"@id\":\"https:\/\/exceltic.serquo.com\/#\/schema\/person\/aa4f97f58379cc64179590f276472ad5\"},\"headline\":\"ETL con Alteryx: Convertir XML a un set de datos relacionales\",\"datePublished\":\"2022-07-26T08:17:04+00:00\",\"dateModified\":\"2022-10-27T07:05:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/\"},\"wordCount\":1351,\"image\":{\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp\",\"articleSection\":[\"Partners\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/\",\"url\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/\",\"name\":\"ETL con Alteryx: Convertir XML a un set de datos relacionales\",\"isPartOf\":{\"@id\":\"https:\/\/exceltic.serquo.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp\",\"datePublished\":\"2022-07-26T08:17:04+00:00\",\"dateModified\":\"2022-10-27T07:05:37+00:00\",\"author\":{\"@id\":\"https:\/\/exceltic.serquo.com\/#\/schema\/person\/aa4f97f58379cc64179590f276472ad5\"},\"description\":\"ETL en Alteryx de un archivo XML, convirti\u00e9ndolo en un set de datos relacional, para facilitar su posterior consumo\",\"breadcrumb\":{\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#primaryimage\",\"url\":\"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp\",\"contentUrl\":\"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp\",\"width\":2560,\"height\":1449,\"caption\":\"ETL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/exceltic.serquo.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ETL con Alteryx: Convertir XML a un set de datos relacionales\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceltic.serquo.com\/#website\",\"url\":\"https:\/\/exceltic.serquo.com\/\",\"name\":\"\",\"description\":\"Ingenier\u00eda y Consultor\u00eda\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceltic.serquo.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/exceltic.serquo.com\/#\/schema\/person\/aa4f97f58379cc64179590f276472ad5\",\"name\":\"Serquo Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/exceltic.serquo.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c335bd9da7b1e9a671364c54e17ba39cb4a646b8eb953383973649c257b1fe49?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c335bd9da7b1e9a671364c54e17ba39cb4a646b8eb953383973649c257b1fe49?s=96&d=mm&r=g\",\"caption\":\"Serquo Admin\"},\"url\":\"https:\/\/exceltic.serquo.com\/en\/author\/serquo\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ETL with Alteryx: Converting XML to a relational dataset","description":"ETL in Alteryx of an XML file, converting it into a relational dataset, to facilitate its further consumption.","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:\/\/exceltic.serquo.com\/en\/creation-and-automation-of-an-etl-convert-xml-to-a-relational-dataset\/","og_locale":"en_GB","og_type":"article","og_title":"ETL con Alteryx: Convertir XML a un set de datos relacionales","og_description":"ETL en Alteryx de un archivo XML, convirti\u00e9ndolo en un set de datos relacional, para facilitar su posterior consumo","og_url":"https:\/\/exceltic.serquo.com\/en\/creation-and-automation-of-an-etl-convert-xml-to-a-relational-dataset\/","article_publisher":"https:\/\/www.facebook.com\/exceltic\/","article_published_time":"2022-07-26T08:17:04+00:00","article_modified_time":"2022-10-27T07:05:37+00:00","og_image":[{"width":2560,"height":1449,"url":"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp","type":"image\/webp"}],"author":"Serquo Admin","twitter_card":"summary_large_image","twitter_creator":"@exceltic","twitter_site":"@exceltic","twitter_misc":{"Written by":"Serquo Admin","Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#article","isPartOf":{"@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/"},"author":{"name":"Serquo Admin","@id":"https:\/\/exceltic.serquo.com\/#\/schema\/person\/aa4f97f58379cc64179590f276472ad5"},"headline":"ETL con Alteryx: Convertir XML a un set de datos relacionales","datePublished":"2022-07-26T08:17:04+00:00","dateModified":"2022-10-27T07:05:37+00:00","mainEntityOfPage":{"@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/"},"wordCount":1351,"image":{"@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#primaryimage"},"thumbnailUrl":"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp","articleSection":["Partners"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/","url":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/","name":"ETL with Alteryx: Converting XML to a relational dataset","isPartOf":{"@id":"https:\/\/exceltic.serquo.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#primaryimage"},"image":{"@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#primaryimage"},"thumbnailUrl":"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp","datePublished":"2022-07-26T08:17:04+00:00","dateModified":"2022-10-27T07:05:37+00:00","author":{"@id":"https:\/\/exceltic.serquo.com\/#\/schema\/person\/aa4f97f58379cc64179590f276472ad5"},"description":"ETL in Alteryx of an XML file, converting it into a relational dataset, to facilitate its further consumption.","breadcrumb":{"@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#primaryimage","url":"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp","contentUrl":"https:\/\/exceltic.serquo.com\/wp-content\/uploads\/2022\/07\/ETL-XML-min-scaled.webp","width":2560,"height":1449,"caption":"ETL"},{"@type":"BreadcrumbList","@id":"https:\/\/exceltic.serquo.com\/creacion-y-automatizacion-de-una-etl-convertir-xml-a-un-set-de-datos-relacionales\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/exceltic.serquo.com\/"},{"@type":"ListItem","position":2,"name":"ETL con Alteryx: Convertir XML a un set de datos relacionales"}]},{"@type":"WebSite","@id":"https:\/\/exceltic.serquo.com\/#website","url":"https:\/\/exceltic.serquo.com\/","name":"","description":"Engineering and Consulting","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceltic.serquo.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/exceltic.serquo.com\/#\/schema\/person\/aa4f97f58379cc64179590f276472ad5","name":"Serquo Admin","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/exceltic.serquo.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c335bd9da7b1e9a671364c54e17ba39cb4a646b8eb953383973649c257b1fe49?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c335bd9da7b1e9a671364c54e17ba39cb4a646b8eb953383973649c257b1fe49?s=96&d=mm&r=g","caption":"Serquo Admin"},"url":"https:\/\/exceltic.serquo.com\/en\/author\/serquo\/"}]}},"_links":{"self":[{"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/posts\/1975","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/comments?post=1975"}],"version-history":[{"count":16,"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/posts\/1975\/revisions"}],"predecessor-version":[{"id":2287,"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/posts\/1975\/revisions\/2287"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/media\/2008"}],"wp:attachment":[{"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/media?parent=1975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/categories?post=1975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltic.serquo.com\/en\/wp-json\/wp\/v2\/tags?post=1975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}