04 – Qlik Sense – Mapping
En esta cuarta entrega, aprenderás a utilizar la función de Qlik Sense “Mapping” para poder añadir una columna más en una tabla existente sin tener que realizar Joins. Si te perdiste la última entrega, visita el artículo cómo utilizar Qlik Sense Join con tablas.
Cómo utilizar Mapping en Qlik Sense
En el vídeo de hoy te explico paso a paso cómo se crea una tabla Mapping y cómo la aplicamos en tablas creadas posteriormente.
Aquí tienes a modo resumen los pasos a seguir tal como se explica en el vídeo:
- Creación del Mapping. La tabla Mapping debe contener únicamente 2 campos: el campo cuyo valor le daremos y el campo cuyo valor devolveremos si hay algún valor coincidente para el campo 1.
Map_ProductID_ProductName:
Mapping
LOAD
"Product ID",
"Product Name"
FROM [lib://escritorio/Datos 1.xlsx]
(ooxml, embedded labels, table is Hoja1);- Aplicación del Mapping en tabla. Utilizamos la función ApplyMap() que consta de 3 parámetros: nombre del Mapping, campo cuyos valores deben coincidir con los valores del primer campo del Mapping, y el valor que le damos para aquellos registros que no coincidan con el Mapping.
Hechos:
LOAD
"ID de Producto",
Tienda,
Fecha,
ApplyMap('Map_ProductID_ProductName',"ID de Producto",'No Product') as ProductName
FROM [lib://escritorio/Datos 2.xlsx]
(ooxml, embedded labels, table is Hoja1);
Con este ejemplo, ya eres capaz de utilizar la funcionalidad Mapping que nos ofrece Qlik Sense. Es un ejemplo senzillo pero es la base de cualqueir ejercicio dónde necesites utilizar dicha función. Para generar la tabla Mapping, también puedes utilizar la función ApplyMap() dentro de ella. Además, dentro de la función ApplyMap() también puedes utilizar otra función ApplyMap() tanto en el 2do parámetro como en el 3ro.
Espero que hayas aprendido de este artículo y te conviertas poco a poco en un experto en Qlik Sense. Si te has perdido las entregas anteriores, te recomiendo que le eches una ojeada al curso Qlik Sense gratuito que ofrezco en mi web HobbieCode.
Si tienes alguna duda o quisieras preguntarme algo, te animo a que dejes un comentario o bien me contactes a través de la página de Contacto en el menú.
Sobre el autor
Hola, que significa luego del applymap antes de “as” colocar + y una de las columnas de la tabla ?
EJemplo:
BOMBAS_DEPRECIACION:
LOAD
*,
APPLYMAP(‘MAP_DEPRECIACION_EXTRA’, KEY_DEPRECIACION_EXTRA, 0) + Depreciacion_Mensual AS Depreciacion_Total;
LOAD
BOMBAS_DEPRECIACION.Fecha & ‘|’ & BOMBAS_DEPRECIACION.Nombre_Interno AS KEY_DEPRECIACION_EXTRA,
BOMBAS_DEPRECIACION.Rendimiento_Minimo AS Rendimiento_Minimo,
BOMBAS_DEPRECIACION.Depreciacion_Mensual AS Depreciacion_Mensual
FROM
……
Your article helped me a lot, is there any more related content? Thanks!
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article. https://accounts.binance.com/bn/register?ref=UM6SMJM3
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Your article helped me a lot, is there any more related content? Thanks!
Your article helped me a lot, is there any more related content? Thanks!
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article. https://accounts.binance.info/register?ref=P9L9FQKY
Your article helped me a lot, is there any more related content? Thanks!
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me. https://www.binance.com/en-ZA/register?ref=JHQQKNKN
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me. https://www.binance.info/sl/join?ref=WTOZ531Y
Your article helped me a lot, is there any more related content? Thanks!
Your article helped me a lot, is there any more related content? Thanks!
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good. https://accounts.binance.info/en-IN/register-person?ref=UM6SMJM3
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good. https://www.binance.info/ro/register?ref=V3MG69RO
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
W81bet, eh? Got my curiosity piqued. Hope the odds are good. Gotta do some digging and see if it’s worth the gamble. w81bet
11winvn, Alright! Sounds like a place with potential. Still need to check it more detailed. If you try it, let me know what you think! Check it out here : 11winvn
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
BetsVIP, como suena de interesante. Si eres VIP, debes probar este sitio, a lo mejor te da suerte. Visiten betsvip y me dicen que tal es.
Your article helped me a lot, is there any more related content? Thanks! https://www.binance.com/register?ref=IXBIAFVY
Been playing on sv88 for a bit. Their live dealer games are pretty awesome, great graphics too. Definitely recommend giving it a shot if you’re into that. Try it out at sv88. Cheers!
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me? https://www.binance.com/sl/register?ref=I3OM7SCZ
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Your article helped me a lot, is there any more related content? Thanks! https://www.binance.com/zh-CN/register?ref=WFZUU6SI
[6827]WJPESO: The Best Online Casino in the Philippines. Easy Login, Register & App Download for Premium Slots and Big Wins. Experience WJPESO, the best online casino in the Philippines. Secure WJPESO login and register to enjoy premium WJPESO slots and big wins. Start your WJPESO app download now for a premium gaming experience anytime, anywhere! visit: wjpeso
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.