Four Stars

How to limit same string data extraction using tmap component

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

20171205_104400.jpg

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

Im so sorry that my english is bad...

 

4 REPLIES
Twelve Stars TRF
Twelve Stars

Re: How to limit same string data extraction using tmap component

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?

TRF
Four Stars

Re: How to limit same string data extraction using tmap component

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

 


 

Twelve Stars TRF
Twelve Stars

Re: How to limit same string data extraction using tmap component

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?


TRF
Four Stars

Re: How to limit same string data extraction using tmap component

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