To get the unique records from the database table you can try the following data flow:
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:
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.