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!!
Solved! Go to Solution.
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
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.
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:
I hope it helps
Thankyou!!