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