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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Using field values in Pre Sql Statement

Meteoroid

Hi,

I need to use Pre SQL Statement to update values of a column using values from one of my fields in the workflow. Sonething like this ....

update table
set columnA = [fieldname]
where columnB = 123 and columnC = 456

Is there a way to do this?


Thanks

Alteryx Alumni (Retired)

You should be able to update the values within the workflow, but if you could elaborate a little more into what the [fieldname] would have to be set as for this work for you it would help me understand the use case a little better. 

Justin Jones
Solutions Engineer
Alteryx
Highlighted
Alteryx Partner

Hi Justin,

 

This is the same sort of solution I am looking for long time. If you want to know why I need that. Here is my requirement. 

http://community.alteryx.com/t5/Data-Sources/Delete-before-insert-in-Output-Tool/m-p/4251

 

It will be very much useful if we can access the fields in output tool.

 

Thanks

Jeeva.

Labels