Mapping csv array and object

Question

Hello, Im trying to map csv to dataset

Im having the follow csv:

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?

RodolfoCh · Accepted Answer

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

~cheers,

Naresh Nakirikanti.

I solvet with this

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

Thank u!

nnakirikanti · Answer

Hello @rodolfoch,Data Prep functions works like champ for me, can you the share the screen of target field mapping as well. ~cheersNaresh Nakirikanti

Sign up