Expand my Community achievements bar.

SOLVED

Incompatible datatypes in source and target dataset in aep

Avatar

Level 2

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee

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

View solution in original post

2 Replies

Avatar

Correct answer by
Employee

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

Avatar

Employee

@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.