how to bulk load data in select box varaible.

[Community Alums]

Hi Connections,

I have a selectbox variable in that i have to show almost 200 drop down values, manually saving is time consuming, any option to bulk load the values...

Regards,

Rafmine.

[Ankur Bawiskar]

@Community Alums 

1st create the variable in that catalog item and then you can load data into the choice list table (question_choice) via data source and ensure the excel has these columns

Question -> storing sysId of your variable

Text -> storing text for the choice i.e. choice label

Value -> storing the choice value

If my response helped please mark it correct and close the thread so that it benefits future readers.

[shubhamdubey]

Hi @Community Alums 

Pls follow this process

1. Add choices data into excel sheet (Text , value , Question(field name of select box))

2. Load the excel sheet(create_import_set) and create a Transform Map

3.Target table (question_choices)

4. Do the automapping(  or Mapping assist)

5. Run the transform Map