How to update and delete a record of a relevant record by selecting the record in a table without using activity by using DT

Blueprint and App Design
, , , ,
1

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?

DT.png
DT.png1388×811 77 KB

2

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.

3

@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.