How to update and delete a record of a relevant record by selecting the record in a table without using activity by using DT
I have to delete and update a record without using the activity. I tried to do the update using DT but unfortunately I was failed to do it. Is there any one who could be able to help me out?
Accepted Solution
Updated: 23 May 2023 9:22 EDT
NCS Pte. Ltd
SG
Hi @PasminaM: To update the data in SOR, you cannot perform it only using data transform. Though there are hacks using RUF, it is not recommended. Data transform is supposed to do the data mapping. You can do the database transactions (update / delete) using savable data pages configuring it in the flow action post processing / smart shape in flow.
Thanks.
Bits in Glass
IN
@PasminaM Data transform mainly used for the data manipulation as well as Mapping. You cannot commit the data with DT.
You must need to write the activity for committing the changes. It would work if you completed the work object.