Populate data from one RecordType to another RecordType

Question

I have a RecordType STG with multiple Records in it. I need to have that data inserted/copied to another RecordType TARGET. Both have the same columns and data types defined in them. 
 With the exception of Unique Identifiers (ID Column) in both the Tables, I want the rest of all columns data to be moved from STG to Target. 
 Can you please advise on how we can do this. I was thinking Script Task in a process model, but need some guidance on this.

Mathieu Drouin · Accepted Answer

You could create a rule (i.e. CopyRecords) that takes a list of the Record Type as input and returns a list of the target Record type: 
 a!localVariables(
 local!records: ri!S_Records_Source,
 local!recordsMap: cast(
 a!listType(typeof(a!map())),
 local!records
 ),
 local!recordsMapWithNoIdentifiers: a!update(local!recordsMap, { "id" }, { null }),
 cast(
 a!listType(
 'recordType!{e10c73fb-040d-4dc2-bd0d-64ba11097acc}S_Record_Target'
 ),
 local!recordsMapWithNoIdentifiers
 )
)

Mathieu Drouin · Answer

1. Rule input needs to be an array. 
 2. You put the recordType object instead of a list of recordTypes. Should look like this.

Mathieu Drouin · Answer

You need to pass the data (the result of a query) not just the record type.

Mathieu Drouin · Answer

Are the columns the same name (including casing) and type? 
 If not, you'll have to map them manually using a forEach like below

Mathieu Drouin · Answer

a!writeRecords is only meant to be used in an interface. 
 For a Process Model, you will need a script task with your expression rule that you store in a PV and a Write Records node.

Populate data from one RecordType to another RecordType

Top Replies