How to limit same string data extraction using tmap component

[Anonymous]

Hello everyone, i'm a new member in this community..

i wanna to ask about ETL using Tmap Component in talend Data Integration

How to check our data existance during extracting using tmap?

---case study----

i have 3 table in tinput component 1 table input and 2 table for lookup which input table contain a string data. I want just one string data that allow to extract to output table..if in output data there is a same string data, tmap must reject it

I hope all of this forum member can help me about this...Thanks before

Im so sorry that my english is bad...

[TRF]

Hi,
Do you mean you want to ignore records from main input table as soon as the same value for a given field appears twice or more?

[Anonymous]

Yes you're right...Do you know how to do it? Thanks before

---

[TRF]

Hi,

Use tUniqRow to exclude duplicates.

Then with tMap and the result of tUniqRow, exclude all duplicates including the 1rst one.

Go an idea of how to proceed?

[Anonymous]

could you give me a concept to do it?  im so sorry i dont have an idea to do it..because im new in datawarehouse