How to update existing records(s) and insert as new records if not exists like UPSERT

Question

Hi,

How to update existing records(s) and insert as new records if not exists like UPSERT through Anaplan Connect script for MS SQL Server?

Thanks & regards,

Anil

anildudam · Answer

Hi QuinE,

Thanks for your reply.

We should not delete existing data from the table as per the requirement, so I did other way around like create another stag table just for insert then run the merge query to update or insert main table through Windows batch script of SQLCMD like below.

Anaplan support team helped me on the sqlcmd solution.

Thanks & regards,

Anil

QuinE · Answer

Hi @anildudam - there is no real way to do this with Anaplan Connect except to flush and refill your Anaplan target.