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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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