https://community.qlik.com/t5/QlikView/How-to-combine-data-from-2-different-excel-and-reference-it-to-a/m-p/1757097#M719412 <P>I might be missing something but if you concatenate both files and then join in the 100 id file by the old ID field you should be able to see where they match.&nbsp;</P> Thu, 29 Oct 2020 15:29:44 GMT villegasi03 2020-10-29T15:29:44Z https://community.qlik.com/t5/QlikView/How-to-combine-data-from-2-different-excel-and-reference-it-to-a/m-p/1756897#M719411 <P>There is two excel files that i want to load them together. [File A and B]</P><P>These files contains 2 column. New ID number and Old ID number.</P><P>I need to combine these 2 excel together, once they are combined together i have a another file with only 100 OLD ID Number.</P><P>I need to find the new ID number for these 100 ID from file A and B.<BR />Table C is the main data i want to keep.</P><P>TableA:<BR /><STRONG>LOAD</STRONG> [OLD ID XXX] as [OLD ID],<BR />[NEW ID]<BR /><BR />FROM<BR />xxxx<BR />(txt, utf8, embedded labels, delimiter is ',', msq);<BR /><BR />Join (TableA)<BR /><BR />TableB:<BR /><STRONG>LOAD</STRONG> [OLD ID XXX] as [OLD ID],<BR />[NEW ID]<BR /><BR />FROM<BR />xxxx<BR />(txt, utf8, embedded labels, delimiter is ',', msq);</P><P>left join<BR /><BR />TableC:<BR /><STRONG>LOAD</STRONG> [ID NUMBER] as [OLD ID],<BR />FROM<BR />XXXX</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-combine-data-from-2-different-excel-and-reference-it-to-a/m-p/1756897#M719411 Novelchew 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/How-to-combine-data-from-2-different-excel-and-reference-it-to-a/m-p/1757097#M719412 <P>I might be missing something but if you concatenate both files and then join in the 100 id file by the old ID field you should be able to see where they match.&nbsp;</P> Thu, 29 Oct 2020 15:29:44 GMT https://community.qlik.com/t5/QlikView/How-to-combine-data-from-2-different-excel-and-reference-it-to-a/m-p/1757097#M719412 villegasi03 2020-10-29T15:29:44Z