How to Import choices field when the type is 'Name-Value Paris' using transform Map ?

[Vijay Kumar21]

For the choices field, we have two different section Name and value which needs to be populated while importing the excel sheet using transform Map.  Please let me know your suggestions 

Sample Data:- 

Above sample data, I need to import in Choice Field for type (Name-Value)

[MrMuhammad]

Hi,

What kind of data in excel sheet you have that you want to map to this name-value pair field? Sample data would be helpful.

Regards,

Muhammad

[Vijay Kumar21]

I have updated my Question and added sample data

[MrMuhammad]

I'm not able to understand why you are using name-value pair as a target field here if you can explain that would be great.

However, in your transform script, you can try something like this.

//replace u_choice with the name of the field from source table/import set. 
var name = source['u_choice'].getLabel();

//replace u_name_value_pair with the name of the target field.
target.u_name_value_pair[name] = source.u_choice;

[Vijay Kumar21]

I have added the sample data in the question. 

kindly do needful