Incompatible datatypes in source and target dataset in aep | Community
Skip to main content
S
Sushmita32
Level 2
March 14, 2024
Solved

Incompatible datatypes in source and target dataset in aep

  • March 14, 2024
  • 2 replies
  • 810 views

Hi,

I have a source dataset(data coming from salesforce) which has a field of type integer but in my target dataset i have created and mapped the same field of type string and i also want it of type string which will result in datatype mismatch and batches will fail.How can I obtain the data in string format?

    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 Kumar29917170hcyp

    Hi @sushmita32 ,

    Use DataPrep function and enclose the field value with double quotes to convert the column value to string.


    Function- concat("",column_name,"")
    Link to get the details of all the DataPrep functions available with examples:
    https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions

     

    Regards,

    Kumar Saurabh

    2 replies

    K
    Adobe Employee
    Kumar29917170hcypAdobe EmployeeAccepted solution
    Adobe Employee
    March 14, 2024

    Hi @sushmita32 ,

    Use DataPrep function and enclose the field value with double quotes to convert the column value to string.


    Function- concat("",column_name,"")
    Link to get the details of all the DataPrep functions available with examples:
    https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions

     

    Regards,

    Kumar Saurabh

      NimashaJain
      Adobe Employee
      NimashaJainAdobe Employee
      Adobe Employee
      March 15, 2024

      @sushmita32 Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.

      Terms & ConditionsAccessibility statement

      Loading footer...