Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Query

Arpita23
7 - Meteor

Hi

How to update values of database using interface tools.

For example i want to update ID and salary values so for that how will I create a macro?

6 REPLIES 6
randreag
11 - Bolide

hi @Arpita23 

 

 

You could use a formula to build your update, then put some interface tool over the formula to send the values

and finally connect the formula with a Dynamic input IN-db , where you shoud select the name of the connection and the update you just build.

 

I hope it helps

Arpita23
7 - Meteor

can you attach a solution?

messi007
15 - Aurora
15 - Aurora

@Arpita23,

 

Please see below how you can do it:

 

messi007_0-1614871633132.png

Attached the workflow,

Hope this helps!

 

Regards

Arpita23
7 - Meteor

Suppose this is the data I want to update like name and Id then how will i do it?

messi007
15 - Aurora
15 - Aurora

@Arpita23,

 

Below how you can do it:

 

messi007_0-1614875021622.png

Attached the workflow,

 

If this solves the issue please mark it as solved it will help others.

 

Regards,

Arpita23
7 - Meteor

Thankyou!!

Labels