Import into sys_choice does not recognize Table column

[hanaphouse]

I am trying to load this data into the sys_choice table, however, the Table column is not recognized during import.

Excel content:

Transform Map:

Table field is ignored:

What could be wrong here?

[Nitin_NOW]

What are the fields missing in the error message? It might be that fields on your excel file does not match with Target table fields. Please map the fields using the Mapping Assist in the Transform Map, which allows you to map the fields manually to the correct one's. 

Please hit correct if this resolves your issue.

Thanks

Nitin

[hanaphouse · Accepted solution]

Upon further checking, I found a HI Known Issue KB article which requires me to modify the system property 'glide.import_template.field_types_to_ignore'.
https://hi.service-now.com/kb_view.do?sysparm_article=KB0758186

After doing it, the Table column was now imported.

[Barrilito van D]

Hi Hanaphouse,

When you run your import from the xls / xlsx datasource you can define from which row it should start. It defaults to "1", so when running the import it picks row 1 and sees "Table" as the first entry of what you defined as a table name, and the table name "Table" does not exist. So set the import to start at row 2 🙂  Ik think that will do the trick.

---

If you think my answer put you in the right direction or you appreciated my effort, please mark the response as Helpful (👍). That way other people in the community will probably be triggered to read the responses too. If my answer solved your issue, please mark my response as Correct (✅). In the list of question people like me that want to help out will know your question was already answered and others that are curious to the answer know a good answer is given in the thread.
Thanks in advance! Good luck!

[hanaphouse]

It was not the issue though.

Upon further checking, I found a HI Known Issue KB article which requires me to modify the system property 'glide.import_template.field_types_to_ignore'.
https://hi.service-now.com/kb_view.do?sysparm_article=KB0758186

After doing it, the Table column was now imported.