Is there any way to do a REPLACE instead of an INSERT in the BULK INSERT feature?

Andreu Companys
Andreu Companys Active Partner
Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board First Anniversary First Comment
edited May 2023 in Platform

I'm trying to get a hierarchy directly upload from BOARD to a SQL Server, so this way we have the hierarchy on SQL and we can use it in our Views and Querys.

The way that the BULK INSERT works let's me upload it, but every time I try to upload it again I will get a duplicate. I only want to have one register for every key value (In this case it is the child entity of the hierarchy). This will work if instead of using the INSERT command we use instead the REPLACE command.

Can you use other commands in the BULK INSERT feature other than the INSERT?

Is there any other way to upload this hierarchy to a SQL Server only using BOARD?

Tagged:

Answers