Hi,
I am trying to upload a CSV in AEP Customer Data Platform - having 3 fields, Email, Product_Key and Update_Timestamp.
The Field - Product_Key is an Array Field as shown below for reference.
I have created Schema and Datasets for the required upload and ingesting the data by mapping to target fields. But somehow AEP is not reading the Array properly. Is the below mentioned Array format readable in AEP? Or do I need to create a Calculated Field while mapping the CSV fields to Target Schema?
Please suggest.
Thanks.
Solved! Go to Solution.
It has nothing to do with AEP. The CSV files structure does not support Arrays. If you look in your key column, you see you have a comma in the field value. That for a CSV file is interpreted as a field delimiter.
While I recommend using a JSON file instead, if you have no other option, you need to pass in multiple fields an create a calculated field to build it on the fly using a combination of data prep functions. https://experienceleague.adobe.com/docs/experience-platform/data-prep/functions.html%3Flang%3Dsv#obj...
Specifically I'd consider:
to_object
to_array
str_to_object
It has nothing to do with AEP. The CSV files structure does not support Arrays. If you look in your key column, you see you have a comma in the field value. That for a CSV file is interpreted as a field delimiter.
While I recommend using a JSON file instead, if you have no other option, you need to pass in multiple fields an create a calculated field to build it on the fly using a combination of data prep functions. https://experienceleague.adobe.com/docs/experience-platform/data-prep/functions.html%3Flang%3Dsv#obj...
Specifically I'd consider:
to_object
to_array
str_to_object
Thank you! That's really helpful.
I believe I have to use CSV file for now. Can you suggest for the above example in the screenshot, what will be the accurate Syntax and example for the same?
I looked into the document that you shared but needed some help on how to convert the above array in SS specifically.
Thank you!
Views
Replies
Total Likes
You can use split to achieve what you need.
Hi,
I tested and it seems to be working.
For a csv structured like this:
Views
Replies
Total Likes
Views
Likes
Replies