Filter in tMap to avoid already existing features

tpozzana · ‎2022-06-16

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 · ‎2022-06-16

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 · ‎2022-06-17

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

Related Topics