Key Value Mapping in AEP | Community
Skip to main content
T
trojan_horse
Level 3
April 9, 2024
Solved

Key Value Mapping in AEP

  • April 9, 2024
  • 3 replies
  • 1375 views

Hi, 

 

I have a bit of an urgent ask. 

 

Is there a way to create a mapping between a code we ingest in AEP and it's value which we won't be ingesting. As an example if we have the code [1 - 10000] ingested in AEP, is there an easy way to assign values to these codes such as 1 -> A and 2 -> B. We would also like to use these values in AJO?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by vinodkomiri

Hi @trojan_horse ,

 

One way you can use this is to model the matching data as lookup data in the AEP. Like you ingest the code in the Actual dataset and profile reference through schema attribute to the value in the lookup schema. As your are going to mark the code as primary identity in the lookup schema (Use non-people identifier) you would be able to use the Entity lookup API from the AJO Journey to send a API request for the code and fetch the corresponding value and use in your journey. 

 

Regards,

Vinod

3 replies

K
Adobe Employee
Kumar29917170hcypAdobe Employee
Adobe Employee
April 9, 2024

Hi @trojan_horse ,

One way to handle this problem is by using Dataprep functionality and  transform the data at the time of ingestion. This will require you to write a one time DECODE logic to implement it.

 

Regards,

Kumar Saurabh

    T
    trojan_horseAuthor
    Level 3
    April 9, 2024

    @kumar29917170hcyp Is there an easier way to do this as we'll have thousands of records to map which won't be very efficient

      K
      Adobe Employee
      Kumar29917170hcypAdobe Employee
      Adobe Employee
      April 9, 2024

      @trojan_horse 

      Another way would be to use Enums, only if you have a known finite list, but not sure whether the source value or Display name appears in AJO.

       

      Regards,

      Kumar Saurabh

        V
        vinodkomiriAccepted solution
        Level 2
        April 15, 2024

        Hi @trojan_horse ,

         

        One way you can use this is to model the matching data as lookup data in the AEP. Like you ingest the code in the Actual dataset and profile reference through schema attribute to the value in the lookup schema. As your are going to mark the code as primary identity in the lookup schema (Use non-people identifier) you would be able to use the Entity lookup API from the AJO Journey to send a API request for the code and fetch the corresponding value and use in your journey. 

         

        Regards,

        Vinod

          Terms & ConditionsAccessibility statement

          Loading footer...