Expand my Community achievements bar.

Join us on September 25th for a must-attend webinar featuring Adobe Experience Maker winner Anish Raul. Discover how leading enterprises are adopting AI into their workflows securely, responsibly, and at scale.
SOLVED

Mapping csv array and object

Avatar

Level 2

Hello, Im trying to map csv to dataset 

 

Im having the follow csv:

SKUSizeColor
10214039001|10233324003|1025377500910|BOYS 6|10.5B1O SAPP|M19 SMO|ALU ALU
   

 

and  the follow schema:

RodolfoCh_0-1731599077761.png

 

I tried using the following transformation:

arrays_to_objects("SKU", explode(SKU, "\\|"), "_sportline.Color", explode(Color, "\\|"))

However, it only worked for the SKU column and not for Color. Could you please help me resolve this issue?

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 2

I solvet with this

Using Split with subarrays, and arrays_to_object to main arrays or main object

RodolfoCh_0-1732633639450.png

 

 

Thank u!

 

View solution in original post

4 Replies

Avatar

Community Advisor

Hello @RodolfoCh,

Data Prep functions works like champ for me, can you the share the screen of target field mapping as well.

 

nnakirikanti_0-1732307913917.png

~cheers

Naresh Nakirikanti

Avatar

Level 2

I already solvet it

Thank u!

 

 

Avatar

Community Advisor

Hello @RodolfoCh,

 

If you could share the answer, that would be fantastic so that the community can benefit from it.

 

~cheers,

Naresh Nakirikanti.

Avatar

Correct answer by
Level 2

I solvet with this

Using Split with subarrays, and arrays_to_object to main arrays or main object

RodolfoCh_0-1732633639450.png

 

 

Thank u!