topic Re: Filter in tMap to avoid already existing features in Talend Studio

Filter in tMap to avoid already existing features

tpozzana — Thu, 16 Jun 2022 14:30:30 GMT

Hi friends,

I have a little job to insert a simple Excel file to a table PostgreSQL.

I have 7 fields : month, year, name1, name2, town, value.

I would like to put a filter because I don't want to insert in my database any feature that already

exists

I don't know where I have to put this filter, that concerns "

month+year+name1+name2+town".

Thank you very much for your help.

Best regards.

Tancredi

InfoCraft — Thu, 16 Jun 2022 15:24:13 GMT

Hi @Not defined Not defined,

does the table have a primary key?

if not, try to adapt this method to your case

I did it quickly to give you an idea.

Kind regards,

Anonymous — Fri, 17 Jun 2022 07:30:29 GMT

Hello,

Here is a response in your another topic about:

Please stick to one topic so that we could pay individual attention to your issue.

Best regards

Sabrina