How to get distinct combination of two columns from two tables

[desanip]

Hello everyone,

I want to a distinct combination of two columns from two different tables ( Say A and B) and then insert them to a different table. How do i achieve this in Talend? can i achieve this in tmap? or should i use a different component? Please advice. 

[manodwhb · Accepted solution]

First sort the data based on two columns and then use tuniquerow component on those two columns to get distinct data.