How to ingest a Flat Json like the below format into an array

[gengaipandi03]

Hi, 

Is there any option to upload the following format to be uploaded into array object?

vcClientHash	adhoc_object
1PhAha2uRgKsNk99BHMl	[{"Updatedate":"2025-07-24","CampaignName":"MR_ETAOEA_202506_90_CS1DailyDose","Cell":"unsubscribed"}]

[Devyendar]

@gengaipandi0 are you converting string to array in Data Prep functions in any Source Data Flow? You can use functions such as to_array(true, "Hello", "world") to convert static to array that meets your array object structure.

Here is a list of all supported data prep functions : https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions

[gengaipandi03]

Hi, 

VcclientHash is one column and adhoc_object is the another column where i want to separate the updatedate, campaignname and cell values into their respective fields. Can you show me the formula to do so. 

vcClientHash	adhoc_object
1PhAha2uRgKsNk99BHMl	[{"Updatedate":"2025-07-24","CampaignName":"MR_ETAOEA_202506_90_CS1DailyDose","Cell":"unsubscribed"}]