https://community.qlik.com/t5/Talend-Studio/What-is-the-difference-between-quot-Unique-Match-quot-quot-First/m-p/2247914#M32943 What is the difference between " Unique Match","First Match","All Matches" in Match Model of tMap lookup table? Wed, 17 Oct 2012 13:54:29 GMT Anonymous 2012-10-17T13:54:29Z https://community.qlik.com/t5/Talend-Studio/What-is-the-difference-between-quot-Unique-Match-quot-quot-First/m-p/2247914#M32943 What is the difference between " Unique Match","First Match","All Matches" in Match Model of tMap lookup table? Wed, 17 Oct 2012 13:54:29 GMT https://community.qlik.com/t5/Talend-Studio/What-is-the-difference-between-quot-Unique-Match-quot-quot-First/m-p/2247914#M32943 Anonymous 2012-10-17T13:54:29Z https://community.qlik.com/t5/Talend-Studio/What-is-the-difference-between-quot-Unique-Match-quot-quot-First/m-p/2247915#M32944 Hi, <BR />"Unique" will match with the last key into the lookup, then if you have several rows with the same key, this will the last will match. <BR />Contrary to the "First match" which will match with the first loaded row into the lookup if several rows have same key. <BR />"All matches" : if several matches are found in the Inner Join, i.e. rows matching the explicit join as well as the filter, all of them will be added to the output flow Wed, 17 Oct 2012 22:56:01 GMT https://community.qlik.com/t5/Talend-Studio/What-is-the-difference-between-quot-Unique-Match-quot-quot-First/m-p/2247915#M32944 Anonymous 2012-10-17T22:56:01Z