https://community.qlik.com/t5/App-Development/Data-Cleaning-with-Mapping/m-p/1741082#M56743 <P><SPAN>This worked, thank you so much Lisa</SPAN></P> Thu, 03 Sep 2020 18:10:30 GMT Rosario_Aguilar 2020-09-03T18:10:30Z https://community.qlik.com/t5/App-Development/Data-Cleaning-with-Mapping/m-p/1680131#M51743 <P>Hello good afternoon to everyone.</P><P>For my learning, I am performing an example of data cleaning.</P><P>I download an excel file with data from the following page and add fields, with the intention of cleaning them: <A href="https://www.simonsezit.com/article/excel-crash-course-data-cleaning-in-excel-in-1-hour/" target="_blank">https://www.simonsezit.com/article/excel-crash-course-data-cleaning-in-excel-in-1-hour/</A></P><P>I would like to do the following:<BR />1.-Change the data "The Beatles." , "Beatles.", "Beatles" for "The Beatles" with mapping or another form.<BR />2.- Delete rows and columns without data.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Limpieza de datos.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29274i6FAD1ED4B9ECADC2/image-size/large?v=v2&amp;px=999" role="button" title="Limpieza de datos.png" alt="Limpieza de datos.png" /></span></P><P>I hope you can help me, I'm new.</P><P>I did a maping, but apparently I'm not applying it well, because it changes all the artists.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ejemplo.png" style="width: 781px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29275i62649A9EEA0B27B1/image-size/large?v=v2&amp;px=999" role="button" title="ejemplo.png" alt="ejemplo.png" /></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 19:01:36 GMT https://community.qlik.com/t5/App-Development/Data-Cleaning-with-Mapping/m-p/1680131#M51743 Rosario_Aguilar 2024-11-16T19:01:36Z https://community.qlik.com/t5/App-Development/Data-Cleaning-with-Mapping/m-p/1680132#M51744 <P>In your applymap, don't include 'The Beatles' if not found:<BR />.</P><P>Applymap('AlbumMusica_MAP', Artist) as Artist,</P><P>..</P> Fri, 28 Feb 2020 00:54:23 GMT https://community.qlik.com/t5/App-Development/Data-Cleaning-with-Mapping/m-p/1680132#M51744 Lisa_P 2020-02-28T00:54:23Z https://community.qlik.com/t5/App-Development/Data-Cleaning-with-Mapping/m-p/1741082#M56743 <P><SPAN>This worked, thank you so much Lisa</SPAN></P> Thu, 03 Sep 2020 18:10:30 GMT https://community.qlik.com/t5/App-Development/Data-Cleaning-with-Mapping/m-p/1741082#M56743 Rosario_Aguilar 2020-09-03T18:10:30Z