Mapping to key value pair field(AEP)

[Abhijeet_JKa]

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

[Hey_John · Accepted solution]

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

Thanks,

John

[kautuk_sahni]

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