0 Replies Latest reply: Jun 22, 2018 4:56 PM by Stacy Vickery RSS

    How do I resequence my load file?

    Stacy Vickery

      currently loading

       

      LOAD @1 as QN_Age,
      @2 as QN_Notification,
      @3 as QN_RejectQty,
      @4 as QN_MaterialNo,
      @5 as QN_StandardPrice,
      @6 as QN_MaterialGRoup,
      @7 as QN_SupplierNo,
      @8 as QN_SupplierName,
      @9 as EKGRP,
      @10 as QN_Value,
      @11 as QN_Responsibility,
      @12 as QN_DiscpcyShortTxt,
      @13 as QN_LongTxt
      FROM

       

      would prefer it to load like this

       

       

      LOAD @9 as EKGRP,
      @1 as QN_Age,
      @2 as QN_Notification,
      @3 as QN_RejectQty,
      @4 as QN_MaterialNo,
      @5 as QN_StandardPrice,
      @6 as QN_MaterialGRoup,
      @7 as QN_SupplierNo,
      @8 as QN_SupplierName,
      @10 as QN_Value,
      @11 as QN_Responsibility,
      @12 as QN_DiscpcyShortTxt,
      @13 as QN_LongTxt
      FROM