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

Alteryx designer Discussions

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

Use a select query output to update a column value (not using 'Append Fields' tool)

Asteroid

Hi Peers,

 

Is there a way I can use a select query output to update a column value using a tool (without using 'Append Fields' tool). So, in my case, I am trying to update an ID column value at the end of the workflow before inserting rest of the data into the table. So, my select query output would have an ID value which I want to update in input prior to output tool writing data into Database.

 

Please advise. Thanks! 

Alteryx Certified Partner

Hi there

 

I don't fully understand what you are trying to achieve. Can you create a simple example workflow with your input and expected output? A Select tool won't change and values other than column headers.

 

Cheers

 

G

Labels