Mapping csv array and object

[RodolfoCh]

Hello, Im trying to map csv to dataset 

Im having the follow csv:

SKU	Size	Color
10214039001|10233324003|10253775009	10|BOYS 6|10.5	B1O SAPP|M19 SMO|ALU ALU

and  the follow schema:

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?

[nnakirikanti]

Hello @RodolfoCh,

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

~cheers

Naresh Nakirikanti

[RodolfoCh]

I already solvet it

Thank u!

[nnakirikanti]

Hello @RodolfoCh,

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

~cheers,

Naresh Nakirikanti.

[RodolfoCh · Accepted solution]

I solvet with this

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

Thank u!