From the look-up data before you connect to tmap, if it is db you can write a query to eliminate duplicates or you can use tuniquerow component to remove duplicates.
I have to take main Flow PID and need to Lookup in that table PiD if it matches that matched Startkey need to check between Lookup cstartkey if it is matched then status 'active' else 'inactive'.