Mapping to key value pair field(AEP)

Question

{Lamp=6, Sensor=3}This comes under a particular field as string in CSV file.I need to ingest the file and map this particular field to a key value pair field(key-lamp and value-6).Can anyone please help me with this.Or can anyone help me with any other way to ingest this data.

John_Man · Accepted Answer

Hi @abhijeet_jka

It's not exactly your case, but I've tried to extract a string field delimited by "|" and add the values to the standard Product String array object, hope it can give you some idea, there are other similar Data Prep functions that you can try as well.

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform/data-not-getting-ingested-into-array-type-objects-using-csv-file/m-p/703525#M5572

Thanks,

John

kautuk_sahni · Answer

@abhijeet_jka Did you find the suggestion helpful? Please let us know if you require more information. Otherwise, please mark the answer as correct for posterity. If you've discovered a solution yourself, we would appreciate it if you could share it with the community. Thank you!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded