Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
aruiz-itp
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

@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

@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