How to map CDT

Question

Hello, 
 
 I have a requirement where I need to map data in one CDT to another. The two CDT's are as below 
 
 DS_SeparatedData which includes FieldIdentifier,DataValue,Datacaption and Keyidentifier - These values are coming from database, Now what I want is I want to map the value of FieldIdentifier and DattaValue manually from another variable. So my another variable would be: VD_SeparatedData which includes FieldIdentifier and DataValue. As per the value available in VD_SeparatedData variable, I want to update the value in DS_SeparatedData. for eg: 
 Lets say my DS_SeparatedData consists of following value. i.e. 
 DS_SeparatedData 
 FieldIdentifier:"Email" 
 DataValue:abc@abc.com 
 Datacaption: "Email ID" 
 KeyIdentifier:2 
 
 VD_SeparatedData 
 FieldIdentifier:"Email" 
 DataValue:pqr@xyz.com 
 
 So I want DataValue in VD_SeparatedData variable to get updated in DS_SeparatedData as FieldIdentifier is same on both the variable.

mohamedt808 · Accepted Answer

Try this ,

a!forEach( 
items:ri!SeparatedData_CDT, 
expression:{'type!{urn:com:appian:types}WebLaunchParameters'( 
ProcessDataCaption: ri!SeparatedData_CDT[fv!index].ProcessDataCaption, 
FieldIdentifier: ri!SeparatedData_CDT[fv!index].FieldIdentifier, 
ProcessDataLaunch: ri!SeparatedData_CDT[fv!index].ProcessDataLaunch, 
ProcessDataOptional: ri!SeparatedData_CDT[fv!index].ProcessDataOptional, 
ProcessDataValue: index(ri!VD_Datasubset.ProcessDataValue,wherecontains(ri!SeparatedData_CDT[fv!index].FieldIdentifier,ri!VD_Datasubset.FieldIdentifier),""), 
KeyFormAttributeType: ri!SeparatedData_CDT[fv!index].KeyFormAttributeType, 
FormAttributeValue: ri!SeparatedData_CDT[fv!index].FormAttributeValue 
)} 
)

aloks0189 · Answer

Hi for your requirement, you can create an expression rule, which will have your CDT as input parameter (which is having the value). 
 
Now use type!yourCDT( 
All property of your desired CDT: required value 
) 
 
Where type!yourCDT() is of your desired type CDT which you want to get as an output/response. 
 
This should do your job.

aloks0189 · Answer

The parameter should be the CDT which is having the values, from which you want to copy the values to another CDT. 
 
Let's say CDT A is having value which you want to copy into CDT B, then CDT A should be parameter and inside rule you use 
 
type!B( 
FieldIdentifier: ri!B.FieldIdentifier, 
DataValue: something 
) 
 
I assume FieldIdentifier and DataValue along with other properties(optional) are the property of your CDT B 
 
Hope this will help you

aloks0189 · Answer

type!B is nothing but, will be used to form a the original variable. Let's say In your case actual cdt in which you want to copy the data, if its name is Employee then you could declare it as follows:

type!Employee( 
empName: ri!otherCDT.empName, 
email: "abc@test.com", 
identifier: ri!otherCDT.eventIdentifier 
) 
 
Assume empName, email & identifier are the properties of your Target/Actual CDT where as empName, eventIdentifier is the property of your parameterized CDT which has the value 
 
Here type!Employee() will prepare a CDT object of type Employee 
 
Also, if you want to generate array of CDT then you need to make the use of looping functions such as: a!forEach(), apply() etc..

Hope this will help you.

smriti p0001 · Answer

you can simply set value of age from cdtB , like CDT A. Age = CDT b.Age in loop. so the final CDT will have all three fields with updated value