Hi,
To get the unique records from the database table you can try the following data flow:
![image](https://lh5.googleusercontent.com/XNu-IBCLU5ZxLrEfKZPxITklbeKKm7uTCpAM3__QeETpvt6hVqqjxkvdwVOUSKrFl5hXff_rw8GerRoq0W2jFydrAK7m02-EamqPDmmWKB7pKpWtRYFvhnLqSdW5fueQjh81Llkg)
Make sure to keep your database input as main flow and the excel iput as a lookup.
Once you are done setting up the components, go to the tMap Editor and perform the following operations:
![image](https://lh5.googleusercontent.com/sn_ZlP3HF_pK5FcYRm0gvZZvmU019t6PRz0cVKGTkKp_rMl7efNXvgrefBcw28YlyGdSmj6mquni_Gsnq4sIU9As6JavK3pekkBMRb_3DH2RGvsxVHrUOax2miVf4Yb9g2a-TIzR)
-
Click on tMap settings of row2 table.
-
Set the “Match model” and “Join Model” as “Unique Match” and “Inner Join” respectively.
-
Click on tMap settings of output table.
-
Set the “Catch look up inner join reject” as “true”
-
Map the rows from the database incoming flow to the output table
And there you go.
Execute the job, you will get the required output with all unique records.