Transform Map not mapping to correct Question record

[MBarrott]

Not entirely sure where the issue is on this. 

I have 3 dropdown fields all named the same thing. I would like to load the dropdown options into the question_choice table for all 3 at once. 

Since they're named the same I cannot find the correct question record via the name so instead, I've got a field for the Question sys_id. This is then being mapped on the question table - sys_id field. (See attached). I also tried mapping it just to the Question field on the question table, but same result. 

When I was also importing the Question field, they all mapped to only one of the questions. 

With the Question field not included in the import, the data is importing but not mapping to a question field, instead just (empty). 

[Mark Manders]

Because 'sys id' on the target table is the sysid of the choice you are creating. You can't set that. You need to map it to the 'question' field (question is a reference field, containing the sysid of the question record).