topic Data Cleansing in QlikView https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252562#M854161 <HTML><HEAD></HEAD><BODY><P>What is data cleansing in Qlikview and how it works?</P><P></P><P>Thank You.</P><P></P><P>Best</P><P>Prachi</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Data Cleansing https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252562#M854161 <HTML><HEAD></HEAD><BODY><P>What is data cleansing in Qlikview and how it works?</P><P></P><P>Thank You.</P><P></P><P>Best</P><P>Prachi</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252562#M854161 Anonymous 2020-11-25T16:16:04Z Re: Data Cleansing https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252563#M854162 <HTML><HEAD></HEAD><BODY><P>refer this</P><P></P><P><A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/LoadData/data-cleansing.htm" title="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/LoadData/data-cleansing.htm">https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/LoadData/data-cleansing.htm</A></P></BODY></HTML> Thu, 23 Feb 2017 11:21:07 GMT https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252563#M854162 dsharmaqv 2017-02-23T11:21:07Z Re: Data Cleansing https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252564#M854163 <HTML><HEAD></HEAD><BODY><P>Hello Prachi,</P><P></P><P>Please refer below:</P><P><A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/LoadData/data-cleansing.htm" title="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/LoadData/data-cleansing.htm">https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/LoadData/data-cleansing.htm</A></P><P><A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/File_Wizard_Transform.htm" title="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/File_Wizard_Transform.htm">https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/File_Wizard_Transform.htm</A></P><P></P><P>Hope this will help.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Thu, 23 Feb 2017 11:21:37 GMT https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252564#M854163 rahulpawarb 2017-02-23T11:21:37Z Re: Data Cleansing https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252565#M854164 <HTML><HEAD></HEAD><BODY><P>could you explain me in your word?</P></BODY></HTML> Thu, 23 Feb 2017 11:22:51 GMT https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252565#M854164 Anonymous 2017-02-23T11:22:51Z Re: Data Cleansing https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252566#M854165 <HTML><HEAD></HEAD><BODY><P>Data Cleansing is to correct/Prepare the data according to our requirement . In qlikview we have lot of techniques&nbsp; to do the same </P><P>check this </P><P><A href="https://community.qlik.com/qlik-blogpost/4267">Data Cleansing</A></P><P><A href="https://community.qlik.com/thread/3187">Data Cleansing</A></P></BODY></HTML> Thu, 23 Feb 2017 11:24:39 GMT https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252566#M854165 avinashelite 2017-02-23T11:24:39Z Re: Data Cleansing https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252567#M854166 <HTML><HEAD></HEAD><BODY><P>prachi its hard to type that much....just go through the link and if you have any query ....then we can clerify that</P></BODY></HTML> Thu, 23 Feb 2017 11:26:31 GMT https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252567#M854166 dsharmaqv 2017-02-23T11:26:31Z Re: Data Cleansing https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252568#M854167 <HTML><HEAD></HEAD><BODY><P>Hello Prachi,</P><P></P><P>Data cleansing is core concept of E<STRONG>T</STRONG>L (Extract-<STRONG>Transform</STRONG>-Loading). In this process, data is <STRONG>Extracted</STRONG> from different systems then it is passed through the <STRONG>Transformation</STRONG> process and finally <STRONG>Loaded</STRONG> into application/warehouse.</P><P></P><P><STRONG>Transformation</STRONG> (or for a moment say it Data Cleansing) is carried out to maintain the <STRONG>data consistency</STRONG>. For example, we have an enterprise running with several departments such as - Sales, Finance, Marketing etc.</P><P>Country Name field may have different values in every department (Sales - IN, Finance - IND, Marketing - INDIA). To make it consistent we do convert all these values as INDIA.</P><P></P><P>Hope this will be helpful.</P><P></P><P><EM>P.S.: This is just a single example; this is a vast topic.</EM></P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Thu, 23 Feb 2017 11:54:25 GMT https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252568#M854167 rahulpawarb 2017-02-23T11:54:25Z Re: Data Cleansing https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252569#M854168 <HTML><HEAD></HEAD><BODY><P>ya it is very helpful to me. Thank you rahul.</P></BODY></HTML> Thu, 23 Feb 2017 12:03:38 GMT https://community.qlik.com/t5/QlikView/Data-Cleansing/m-p/1252569#M854168 Anonymous 2017-02-23T12:03:38Z