topic Re: Reconciling data files in QlikView https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580564#M1099605 <HTML><HEAD></HEAD><BODY><P>I want to compare all entries into 4 data fields.&nbsp; Ideally they should be the same.&nbsp; I need to identify the descrepancies. for example :&nbsp; Smith, In Pay, $3.50, LIFE vs Smith, In Pay, $4.50, LIFE. </P></BODY></HTML> Tue, 15 Apr 2014 17:50:46 GMT 2014-04-15T17:50:46Z Reconciling data files https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580561#M1099602 <HTML><HEAD></HEAD><BODY><P>I have two data files that I'm trying to reconcile.&nbsp; Once they are loaded, what is the best way to compare them?&nbsp; There seem to be so many options that it boggles my mind.</P></BODY></HTML> Tue, 15 Apr 2014 17:41:32 GMT https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580561#M1099602 2014-04-15T17:41:32Z Re: Reconciling data files https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580562#M1099603 <HTML><HEAD></HEAD><BODY><P>How you want to compare?&nbsp; What is the objective? </P></BODY></HTML> Tue, 15 Apr 2014 17:43:41 GMT https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580562#M1099603 MK_QSL 2014-04-15T17:43:41Z Re: Reconciling data files https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580563#M1099604 <HTML><HEAD></HEAD><BODY><P>1. Check its field name and the data in the fields for matching the records.</P><P>2. If same then concatenate the tables with flag fields.</P><P>3. For which scenario you want to compare the tables and check the data and make charts for comparision.</P><P>4. Basically reconcile is done for financial application then use the financial terms for reconcile method and create a model based on that.</P></BODY></HTML> Tue, 15 Apr 2014 17:44:42 GMT https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580563#M1099604 its_anandrjs 2014-04-15T17:44:42Z Re: Reconciling data files https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580564#M1099605 <HTML><HEAD></HEAD><BODY><P>I want to compare all entries into 4 data fields.&nbsp; Ideally they should be the same.&nbsp; I need to identify the descrepancies. for example :&nbsp; Smith, In Pay, $3.50, LIFE vs Smith, In Pay, $4.50, LIFE. </P></BODY></HTML> Tue, 15 Apr 2014 17:50:46 GMT https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580564#M1099605 2014-04-15T17:50:46Z Re: Reconciling data files https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580565#M1099606 <HTML><HEAD></HEAD><BODY><P>Sharing your sample data file or apps would be great. </P></BODY></HTML> Tue, 15 Apr 2014 18:11:09 GMT https://community.qlik.com/t5/QlikView/Reconciling-data-files/m-p/580565#M1099606 MK_QSL 2014-04-15T18:11:09Z