Import external data into the Choice Table

Weargle
Kilo Explorer

I am attempting to load data to the CHOICE table so I can populate one of my drop down fields on my Incident Form. Everything works except the 'Create Excel Template' does not have the Table column(See SS1). When I import, the Table is blank and I have to set it manually(See SS2). I tried adding Table to the template but it seems to ignore it.

What am I missing?

 

SS1

find_real_file.png

SS2

find_real_file.png

SS3

find_real_file.png

 

3 REPLIES 3

Varsha21
Giga Guru

Hi Weargle,

it seems that you did not add the col into your excel sheet(refer bellow image)

 

find_real_file.png

 

and because of this you are not able to map table field to sys_choice table.

now do the same process using import set,

Navigate import set->load data

find_real_file.png

and submit it.

find_real_file.png

you will get above page,

now see Loaded data in that it is showing you u_test_import_choice table means you have loaded source data into this table(you can check using .list)

the next step is to create transform map

click on it

find_real_file.png

now refer above image

give the name to field,target table in case of you choose sys_choice

save the record and click on Auto Map Matching ,your all fields will be match automatically and then

find_real_file.png

click transform

your record will be insert into expected table ...check it.

 

if helpful mark it correct or helpful..

 

Regards,

Varsha.

 

 

 

 

 

This is best, I have bookmarked it.

Varsha21
Giga Guru

Hi Weargle,

did you try with my solution,it worked for me

 

find_real_file.png

refer above image,

if you find it helpful mark as correct or helpful!!

 

Regards,

Varsha