topic Re: How to limit same string data extraction using tmap component in Talend Studio

How to limit same string data extraction using tmap component

Anonymous — Tue, 05 Dec 2017 03:52:09 GMT

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...

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

TRF — Tue, 05 Dec 2017 07:36:03 GMT

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?

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

Anonymous — Tue, 05 Dec 2017 08:36:09 GMT

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

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

TRF — Tue, 05 Dec 2017 08:44:04 GMT

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?

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

Anonymous — Tue, 05 Dec 2017 08:53:31 GMT

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