Filter in tMap to avoid already existing features

[tpozzana]

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

[Anonymous · Accepted solution]

Hello,

In the tMap, you can click the filter button and write a filter expression to filter the output data.

For more information, please have a look at this KB article:

https://community.talend.com/s/article/tMap-expression-syntax-TCiHW

Best regards

Sabrina