Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

What is the difference between " Unique Match","First Match","All Matc

What is the difference between " Unique Match","First Match","All Matches" in Match Model of tMap lookup table?
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,
"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.
Contrary to the "First match" which will match with the first loaded row into the lookup if several rows have same key.
"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