• State Verified Answer
  • Replies 20 replies
  • Answers 4 answers
  • Subscribers 10 subscribers
  • Views 27317 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

How to map CDT

viveku3486
Certified Associate Developer

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. 

  Discussion posts and replies are publicly visible

  • 0
    Certified Lead Developer
    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.
  • 0
    Certified Associate Developer
     in reply to aloks0189
    Hey Alok, Thanks for quick reply. The parameter which I will pass in expression rule should be my original CDT or the one where updated values are stored? Can you refer the above mentioned variables and implement it in your logic? That will clarify my all doubts. Thanks in advance
  • 0
    Certified Lead Developer
     in reply to viveku3486
    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
  • 0
    Certified Associate Developer
     in reply to aloks0189
    Let me try this between thanks for all your time and efforts.
  • 0
    Certified Associate Developer
     in reply to aloks0189
    Hey Alok,

    How this logic will take effect a change in original variable? We are nowhere passing the original variable
  • 0
    Certified Lead Developer
     in reply to viveku3486
    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.
  • 0
    Certified Associate Developer
     in reply to mohamedt808
    Yes these two CDT's are multiple. Let me give a quick example


    CDT A:[Name=abc,Age=,Gender=Male],[Name=pqr,Age=,Gender=Female],[Name=xyz,Age=,Gender=Male] and so on.

    Similarly CDT B contains
    CDT B:[Name=abc,Age:40],[Name=jkl,Age:60],[Name=xyz,Age:20]

    As You can CDT A is my original CDT which contain all the columns whereas CDT B contains only 2 columns i.e Name and age. In CDT A you can see that "Age" property is blank. So what I need is that I need to update the values in CDT A with the matching values available in CDT B. My Final output would be something like

    [Name=abc,Age=40,Gender=Male],[Name=pqr,Age={Blank as no record for "pqr" is available in CDT B},Gender=Female],[Name=xyz,Age=20,Gender=Male] and so on.
  • 0
    Certified Associate Developer
     in reply to aloks0189
    Hey Alok,

    I don't want to map the data between two different CDT's. I want to map data between two variables of same CDT. Here my variables are different but their CDT is same. for eg, CDT A is one variable of type 'Employee' and CDT B is another variable of same type 'Employee'. Only difference is the number of properties they hold. In this case lets say CDT 'Employee' have 3 fields than variable CDT A contains all the three columns and CDT B contains only two columns. So whatever will be the value inside variable CDT B, I want to make the changes in CDT A.
  • 0 in reply to viveku3486
    As per what you are saying, you can use a simple index function and store these value in the actual CDT.Lets Say variable "a" (DS_SeparatedData?list) and Variable "b" (VD_SeparatedData?list) then store the result of following in variable a.

    a!forEach(
    items:ri!a,
    expression:{'type!{urn:com:appian:types}DS_SeparatedData'(
    Datacaption:ri!a[fv!index].Datacaption,
    KeyIdentifier:ri!a[fv!index].KeyIdentifier,
    DataValue: index(ri!b.DataValue,wherecontains(ri!a[fv!index].FieldIdentifier,ri!b.FieldIdentifier),""),
    FieldIdentifier:ri!a[fv!index].FieldIdentifier)}
    )
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.