Flow Designer Query

[Community Alums]

Hello Team,

I have Requirement to update one filed for particular CI through flow designer . Suppose I have Target table is cmdb_ci and new one is u_cit_ci is staging  table. and one filed is common for both lets say e.g. purpose . Now If I updated purpose on staging form then automatically needs to update purpose on target table for that particular  CI only not for all class. 

Note :- after approval we need to update this , and this needs to be achieve only via flow designer .  

Please advise me how we can achieve this in flow designer is der any option for this particular requirement to write script on the basis of sysid  

[SwarnadeepNandy]

Hello,

You can make the import set in synchronous mode, so that any update on the staging table will perform transformation action.

Now from the flow designer you simply update the staging table and it will perform the transformation. Nevertheless, you have to create your own transform map. You can use Auto mapping to map the fields.

Kind Regards,

Swarnadeep Nandy

[Ankur Bawiskar]

@Community Alums 

what does staging table mean here?

Are you saying you are loading data from external system?

What's the usecase and requirement here?

[Community Alums]

@Ankur Bawiskar any update