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.