topic Re: How to compare rows from two excel sheets in QlikView https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284895#M847339 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can we see a fragment of your original data and the result that you want to get?</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Mon, 27 Mar 2017 11:35:12 GMT ahaahaaha 2017-03-27T11:35:12Z How to compare rows from two excel sheets https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284894#M847338 <HTML><HEAD></HEAD><BODY><P>Friends,</P><P>I have a requirement like,</P><P>1. I want to compare two excel sheets having 7 columns or conditions. It can have many fields in it, many fields can have same names but with different field IDs having 7 different conditions for them. I need to compare a row in the same excel sheet / different excel sheet and split the fields as "Reused fields" and "New fields".</P><P>Plz guys help me to do this....</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284894#M847338 Anonymous 2020-11-25T16:16:04Z Re: How to compare rows from two excel sheets https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284895#M847339 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can we see a fragment of your original data and the result that you want to get?</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Mon, 27 Mar 2017 11:35:12 GMT https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284895#M847339 ahaahaaha 2017-03-27T11:35:12Z Re: How to compare rows from two excel sheets https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284896#M847340 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply Andrey, Plz find the attachment from my original discussion. I want the fields to be grouped based on the business grouping but it should satisfy all the conditions (Qualifier/Enumeration,Data type,Min occurs,Max occurs,M/C/O and Length).</P></BODY></HTML> Mon, 27 Mar 2017 11:50:44 GMT https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284896#M847340 Anonymous 2017-03-27T11:50:44Z Re: How to compare rows from two excel sheets https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284897#M847341 <HTML><HEAD></HEAD><BODY><P>Operator Distinct groups lines 6 and 7 of your source file</P><P></P><P>LOAD <SPAN style="color: #ff0000;">Distinct</SPAN></P><P>...</P><P>From ...</P><P></P><P> Must you combine the values of "Academic Information" in the field "Business Group"?</P><P><IMG alt="1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157705_1.jpg" style="height: 296px; width: 620px;" /></P><P></P><P>If not, then DISTINCT solves the task on a sample of the original data.</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Mon, 27 Mar 2017 12:34:58 GMT https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284897#M847341 ahaahaaha 2017-03-27T12:34:58Z Re: How to compare rows from two excel sheets https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284898#M847342 <HTML><HEAD></HEAD><BODY><P>Why cant we load distinct rows??</P><P style="font-size: 12px; font-family: Arial; color: #636363;">using some work arounds like firstvalue() (because using distinct is not appreciated always.)</P></BODY></HTML> Mon, 27 Mar 2017 12:42:48 GMT https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284898#M847342 Anonymous 2017-03-27T12:42:48Z Re: How to compare rows from two excel sheets https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284899#M847343 <HTML><HEAD></HEAD><BODY><P>Guys,</P><P>I also wanted to compare those conditions based on their field names </P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">(Qualifier/Enumeration,Data type,Min occurs,Max occurs,M/C/O and Length).</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">How to do that one, plz help me with that?</P></BODY></HTML> Mon, 27 Mar 2017 13:07:01 GMT https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284899#M847343 Anonymous 2017-03-27T13:07:01Z Re: How to compare rows from two excel sheets https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284900#M847344 <HTML><HEAD></HEAD><BODY><P>Hi Bose,</P><P></P><P>Why can't you try with group by while extracting from source file.</P></BODY></HTML> Mon, 27 Mar 2017 13:36:02 GMT https://community.qlik.com/t5/QlikView/How-to-compare-rows-from-two-excel-sheets/m-p/1284900#M847344 yoganantha321 2017-03-27T13:36:02Z