topic how to find difference between a table and file in Talend Studio https://community.qlik.com/t5/Talend-Studio/how-to-find-difference-between-a-table-and-file/m-p/2378218#M140029 <P>How to find the difference between a file and a table in talend .</P><P></P><P></P><P>example: i have a file which has below 3 records</P><P></P><P></P><P>1</P><P>2</P><P>3</P><P></P><P></P><P>table has below records:</P><P>2</P><P>3</P><P>4</P><P>5</P><P></P><P></P><P>output:</P><P>1</P><P>4</P><P>5</P><P></P><P></P><P>how to achieve</P> Fri, 15 Nov 2024 23:11:35 GMT sunny3 2024-11-15T23:11:35Z how to find difference between a table and file https://community.qlik.com/t5/Talend-Studio/how-to-find-difference-between-a-table-and-file/m-p/2378218#M140029 <P>How to find the difference between a file and a table in talend .</P><P></P><P></P><P>example: i have a file which has below 3 records</P><P></P><P></P><P>1</P><P>2</P><P>3</P><P></P><P></P><P>table has below records:</P><P>2</P><P>3</P><P>4</P><P>5</P><P></P><P></P><P>output:</P><P>1</P><P>4</P><P>5</P><P></P><P></P><P>how to achieve</P> Fri, 15 Nov 2024 23:11:35 GMT https://community.qlik.com/t5/Talend-Studio/how-to-find-difference-between-a-table-and-file/m-p/2378218#M140029 sunny3 2024-11-15T23:11:35Z Re: how to find difference between a table and file https://community.qlik.com/t5/Talend-Studio/how-to-find-difference-between-a-table-and-file/m-p/2378219#M140030 <P>Hi</P><P>You need to do an inner join on tMap, and get the reject rows, please refer to this KB <A href="https://community.talend.com/s/article/Doing-an-inner-join-using-a-tMap-component-i5Mrr" alt="https://community.talend.com/s/article/Doing-an-inner-join-using-a-tMap-component-i5Mrr" target="_blank">article</A>.</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Mon, 21 Feb 2022 07:30:41 GMT https://community.qlik.com/t5/Talend-Studio/how-to-find-difference-between-a-table-and-file/m-p/2378219#M140030 Anonymous 2022-02-21T07:30:41Z Re: how to find difference between a table and file https://community.qlik.com/t5/Talend-Studio/how-to-find-difference-between-a-table-and-file/m-p/2378220#M140031 <P>Thanks Shong..</P><P>if above approach gives duplicate in the output .. how can i remove it?</P><P>&nbsp;</P> Mon, 21 Feb 2022 10:10:12 GMT https://community.qlik.com/t5/Talend-Studio/how-to-find-difference-between-a-table-and-file/m-p/2378220#M140031 sunny3 2022-02-21T10:10:12Z Re: how to find difference between a table and file https://community.qlik.com/t5/Talend-Studio/how-to-find-difference-between-a-table-and-file/m-p/2378221#M140032 <P>@STAR2 s​&nbsp;, remove the duplicated rows using tUniqRow?</P> Tue, 22 Feb 2022 00:13:59 GMT https://community.qlik.com/t5/Talend-Studio/how-to-find-difference-between-a-table-and-file/m-p/2378221#M140032 Anonymous 2022-02-22T00:13:59Z