Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Query

Arpita23
7 - Meteor

Hi

If we want to update a record using alteryx app how can do it for example if we want to update few cells in database table based on id, than how will we do that?

can someone please tell me with example!!

3 REPLIES 3
fmvizcaino
17 - Castor
17 - Castor

Hi @Arpita23 ,

 

Attached is an analytical app showing how to update values in a conditional formula.

Take a look and let me know if this works for you.

 

Drag and drop the workflow to open its configuration.

 

To learn more about analytical apps: https://www.thedataschool.co.uk/marc-reid/creating-analytic-app-alteryx

 

Best,

Fernando Vizcaino

grazitti_sapna
17 - Castor

Hi @Arpita23,

 

You can go with the Traditional CDC Process, where you can do a join on the Id column to identify the inserts and then you can do a join on all columns to identify the records which are updated.

 

grazitti_sapna_0-1614864123241.png

 

For some of the output DB's we already have a feature to do inserts and updates, you just need to define a PK in Target table and select the option as shown in the screenshot below:

 

grazitti_sapna_1-1614864262565.png

 

I hope it helps

Sapna Gupta
Arpita23
7 - Meteor

Thankyou!!

Labels