<\/a>Filas duplicadas<\/h2>\n\n\n\n\n Habr\u00e1s notado que al final de la explicaci\u00f3n de cada ejemplo puse el n\u00famero m\u00ednimo de filas que la tabla combinada deber\u00eda tener. Existe la falsa concepci\u00f3n de que el resultado de un left join debe tener el mismo n\u00famero que la tabla de la izquierda y un right join que el de la derecha. Esto no es as\u00ed y ver\u00e1s por qu\u00e9 en el siguiente ejemplo.\n<\/p>\n\n\n\n
\n Por ejemplo, tengo una tabla con un listado de clientes junto con el producto que compraron, la cantidad y la fecha de compra.\n<\/p>\n\n\n\n![\"\"](\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-419-1.png\")
<\/figure>\n\n\n\n\n Por otro lado, tengo otra con los precios de los productos.\n<\/p>\n\n\n\n![\"\"](\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-419-2.png\")
<\/figure>\n\n\n\n\n Quiero calcular las ventas totales y para eso tengo que crear una tabla combinada donde pueda ver tanto la cantidad como el precio para poder multiplicarlos. Para eso hago un left join de la tabla clientes a la izquierda con la tabla precios a la derecha y este es el resultado.\n<\/p>\n\n\n\n
![](\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-419-3.png\")
\u00bfNotas algo extra\u00f1o? \u00bfTe has dado cuenta de que el ID de cliente LS-17200 que compra un 3M Office Air Cleaner aparece repetido? <\/p>\n\n\n\n
\n Eso es porque en la lista de precios ten\u00eda 2 distintos para el producto 3M Office Air Cleaner. El campo que he usado para el left join ha sido solo el del nombre de producto, y como este est\u00e1 repetido en la tabla de la derecha, tambi\u00e9n se repetir\u00e1 en la resultante.\n<\/p>\n\n\n\n
\n Para solucionarlo tengo que usar 2 campos de uni\u00f3n: nombre de producto y fecha de compra. De este modo la combinaci\u00f3n sabr\u00e1 que el precio del producto que compr\u00f3 el cliente LS-172000 fue el del 1 de agosto de 2014. \n<\/p>\n\n\n\n
\n Hay que tener cuidado cuando hacemos combinaciones y esperamos que algunas columnas tengan valores \u00fanicos. Si no los tienen, eso nos puede llevar a terminar con valores duplicados en la tabla resultante, como en el ejemplo visto.\n<\/p>\n\n\n\n
<\/a>Performance<\/h2>\n\n\n\n\n Si combinas datasets muy largos, estos pueden tener un impacto en el rendimiento de tu informe. A veces datasets muy largos pueden dar error en Looker Studio y hacer que los gr\u00e1ficos no se carguen, por lo que es mejor evitar hacer combinaciones que tengan un gran n\u00famero de dimensiones. \n<\/p>\n\n\n\n
Hay m\u00e1s problemas que pueden surgir al crear combinaciones en Looker Studio, pero estos son dos de los que m\u00e1s hay que tener en cuenta. Especialmente el primero, ya que una combinaci\u00f3n mal hecha va a mostrar datos incorrectos.<\/p>\n\n\n\n
Si tienes cualquier pregunta, no dudes en dejar un comentario \ud83d\ude42 <\/p>\n","protected":false},"excerpt":{"rendered":"
En este post comento dos de los problemas m\u00e1s comunes a la hora de crear combinaciones en Looker Studio. Si […]<\/p>\n","protected":false},"author":2,"featured_media":1314,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[8],"tags":[4],"class_list":["post-419","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fuentes-de-datos-y-combinaciones","tag-es"],"uagb_featured_image_src":{"full":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false]},"uagb_author_info":{"display_name":"barbmk","author_link":"https:\/\/lookercourses.com\/es\/author\/barbmk\/"},"uagb_comment_info":0,"uagb_excerpt":"En este post comento dos de los problemas m\u00e1s comunes a la hora de crear combinaciones en Looker Studio. Si […]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/comments?post=419"}],"version-history":[{"count":2,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/419\/revisions"}],"predecessor-version":[{"id":2134,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/419\/revisions\/2134"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1314"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/figure>\n\n\n\n\n Por otro lado, tengo otra con los precios de los productos.\n<\/p>\n\n\n\n \n Quiero calcular las ventas totales y para eso tengo que crear una tabla combinada donde pueda ver tanto la cantidad como el precio para poder multiplicarlos. Para eso hago un left join de la tabla clientes a la izquierda con la tabla precios a la derecha y este es el resultado.\n<\/p>\n\n\n\n \n Eso es porque en la lista de precios ten\u00eda 2 distintos para el producto 3M Office Air Cleaner. El campo que he usado para el left join ha sido solo el del nombre de producto, y como este est\u00e1 repetido en la tabla de la derecha, tambi\u00e9n se repetir\u00e1 en la resultante.\n<\/p>\n\n\n\n \n Para solucionarlo tengo que usar 2 campos de uni\u00f3n: nombre de producto y fecha de compra. De este modo la combinaci\u00f3n sabr\u00e1 que el precio del producto que compr\u00f3 el cliente LS-172000 fue el del 1 de agosto de 2014. \n<\/p>\n\n\n\n \n Hay que tener cuidado cuando hacemos combinaciones y esperamos que algunas columnas tengan valores \u00fanicos. Si no los tienen, eso nos puede llevar a terminar con valores duplicados en la tabla resultante, como en el ejemplo visto.\n<\/p>\n\n\n\n \n Si combinas datasets muy largos, estos pueden tener un impacto en el rendimiento de tu informe. A veces datasets muy largos pueden dar error en Looker Studio y hacer que los gr\u00e1ficos no se carguen, por lo que es mejor evitar hacer combinaciones que tengan un gran n\u00famero de dimensiones. \n<\/p>\n\n\n\n Hay m\u00e1s problemas que pueden surgir al crear combinaciones en Looker Studio, pero estos son dos de los que m\u00e1s hay que tener en cuenta. Especialmente el primero, ya que una combinaci\u00f3n mal hecha va a mostrar datos incorrectos.<\/p>\n\n\n\n Si tienes cualquier pregunta, no dudes en dejar un comentario \ud83d\ude42 <\/p>\n","protected":false},"excerpt":{"rendered":" En este post comento dos de los problemas m\u00e1s comunes a la hora de crear combinaciones en Looker Studio. Si […]<\/p>\n","protected":false},"author":2,"featured_media":1314,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[8],"tags":[4],"class_list":["post-419","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fuentes-de-datos-y-combinaciones","tag-es"],"uagb_featured_image_src":{"full":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/Consideraciones-a-la-hora-de-crear-combinaciones-en-Looker-Studio.jpg",700,400,false]},"uagb_author_info":{"display_name":"barbmk","author_link":"https:\/\/lookercourses.com\/es\/author\/barbmk\/"},"uagb_comment_info":0,"uagb_excerpt":"En este post comento dos de los problemas m\u00e1s comunes a la hora de crear combinaciones en Looker Studio. Si […]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/comments?post=419"}],"version-history":[{"count":2,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/419\/revisions"}],"predecessor-version":[{"id":2134,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/419\/revisions\/2134"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1314"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/figure>\n\n\n\n \u00bfNotas algo extra\u00f1o? \u00bfTe has dado cuenta de que el ID de cliente LS-17200 que compra un 3M Office Air Cleaner aparece repetido? <\/p>\n\n\n\n<\/a>Performance<\/h2>\n\n\n\n