community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Unable to Update SQL server

Meteoroid

Sure, After I populate with unique records does it need an update statement still because i just checked PDW doesnot have primary key concept 

Alteryx Certified Partner

Hi @nkothakota ,

 

I have come across an issue like this before where the platform on which the SQL instance was installed was causing the problem. The way I got around it was to create a dummy table and write the records to that table. I then wrote a POST CREATE SQL Statement which copied the records from the dummy table to the existing table. This seemed to get around the problem of directly updating a system tables from an external source. Once the Dummy table was created, it seemed fine with accepting updates from another internal table. I know this is fiddly but it got around the problem for me.

 

post create.PNG

 

M.

Labels