https://community.qlik.com/t5/Talend-Studio/Compare-data-from-two-excel-sheets-to-show-the-changes/m-p/2358025#M123192 Hi,<BR />try following<BR />Option - 1<BR />- Use tMap and have two inputs from two excel files<BR />- In output compare a1 of first input to a1 of second input (a1 is first cell)<BR />--- eg. string can be compared like row1_a1.equals(row2_a1)<BR />--- use if clause, in case if the match is true replace it by null else actual value<BR />-----eg...row1_a1.equals(row2_a1)?"":row2_a2<BR />Second option is a part of first part implementation.<BR />Let us know if you face any issue..<BR />Pl refer to tMap documentation for few scenarios<BR /><A href="https://help.talend.com/search/all?query=tMap&amp;content-lang=en" rel="nofollow noopener noreferrer">https://help.talend.com/search/all?query=tMap&amp;content-lang=en</A> <BR />Thanks<BR />Vaibhav Wed, 28 May 2014 10:04:05 GMT Anonymous 2014-05-28T10:04:05Z https://community.qlik.com/t5/Talend-Studio/Compare-data-from-two-excel-sheets-to-show-the-changes/m-p/2358024#M123191 Compare two excel files, one will be an initial file with "uncleansed data" the second file will have "cleansed data". I need to compare these two files but I need the output to do any of the following if possible:<BR />Option 1 <BR />When the file compare has run if possible; where the record per customer has not changed the in that particular cell under the column where the change has not taken place to leave the cell blank,<BR />where the record has changed that cell must be populated.<BR />Option 2<BR />Alternative to the first option it must show the entire line per customer where a cell has changed but it must somehow uniquely identify the changes.<BR />I am not sure if any of these are possible please advise. Thanks Wed, 28 May 2014 08:56:53 GMT https://community.qlik.com/t5/Talend-Studio/Compare-data-from-two-excel-sheets-to-show-the-changes/m-p/2358024#M123191 Anonymous 2014-05-28T08:56:53Z https://community.qlik.com/t5/Talend-Studio/Compare-data-from-two-excel-sheets-to-show-the-changes/m-p/2358025#M123192 Hi,<BR />try following<BR />Option - 1<BR />- Use tMap and have two inputs from two excel files<BR />- In output compare a1 of first input to a1 of second input (a1 is first cell)<BR />--- eg. string can be compared like row1_a1.equals(row2_a1)<BR />--- use if clause, in case if the match is true replace it by null else actual value<BR />-----eg...row1_a1.equals(row2_a1)?"":row2_a2<BR />Second option is a part of first part implementation.<BR />Let us know if you face any issue..<BR />Pl refer to tMap documentation for few scenarios<BR /><A href="https://help.talend.com/search/all?query=tMap&amp;content-lang=en" rel="nofollow noopener noreferrer">https://help.talend.com/search/all?query=tMap&amp;content-lang=en</A> <BR />Thanks<BR />Vaibhav Wed, 28 May 2014 10:04:05 GMT https://community.qlik.com/t5/Talend-Studio/Compare-data-from-two-excel-sheets-to-show-the-changes/m-p/2358025#M123192 Anonymous 2014-05-28T10:04:05Z