Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
tpozzana
Contributor II
Contributor II

Filter in tMap to avoid already existing features

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

Labels (2)
2 Replies
Covid19
Creator
Creator

Hi @Not defined Not defined​,

does the table have a primary key?

if not, try to adapt this method to your case

0695b00000SpmROAAZ.png0695b00000SpmQMAAZ.png0695b00000SpmTtAAJ.png0695b00000SpmV6AAJ.png 

I did it quickly to give you an idea.

 

Kind regards,

Anonymous
Not applicable

Hello,

Here is a response in your another topic about:

https://community.talend.com/s/question/0D55b00007QPWFsCAP/filter-in-tmap-to-avoid-already-existing-...

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

Best regards

Sabrina