I have a file that I load using a MIG job of the type CREATE_TABLE_FROM_FILE.  The file contains a Task Sequence, Part, Quantity, Delivery required Date and 2 attributes that go on a Technical Class.

I want to create one Mig job to load all the data into the MAINT_MATERIAL_REQ_LINE, the TECHNICAL_OBJECT_REFERENCE and 2 instances of the TECHNICAL_SPECIFICATION.

I have tried

but it stops at the TECHNCAL_OBJECT_REFERENCE when it cannot set the KEY_VALUE correctly as it is MAINT_MATERIAL_ORDER_NO@10 || ‘^’ || LINE_ITEM_NO@10||’^’ and I cannot enter || in the Method  List Attributes Fixed Value column.

I currently have this split across 4 jobs as I also struggled to get it to add 2 TECHNICAL_SPECIFICATION records when trying to group the TECHNICAL_OBJECT_REFERENCE and 2 instances of the TECHNICAL_SPECIFICATION only.  It kept wanting to update the same attribute instead of the second attribute.

Any help greatly appreciated.