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

Alteryx designer Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Update to Table

Asteroid

 

I have a requirement a like this.

 

1) Get Account Record with the status ="New" I used input tools for this.

2) Update imported data with the status ="Pending" 

 

With the Post Create SQL I am able to update.

But I need a update it with out using this Post Create.

Cant it be done by simply using Update query inside any tool?

 

Any idea?

 

Thanks,

Krishna

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Krish

Maybe you can explore the Update: Insert if New method in the Output Tool to get this.

 

Only need is to have your primary keys properly in the table.

 

Best,

_AG_

 

Labels