0 Replies Latest reply: Oct 9, 2014 10:50 PM by Rachel Boey RSS

    join load inline variables to main data load

      Hi, how can I join the load inline variables to OGL?

       

      load *, text(OGLPONUM) as PO_num;

       

      OGL:

      LOAD PO_NUM as OGLPONUM,

           DATE,

           [DR ACCT],

           DR,

           PRICE

      FROM

      [<filename>.xls]

      (biff, embedded labels, table is Sheet1$);

       

      LOAD * INLINE [

          dr_acct, STORE

          $(ASTORE), A

          $(BSTORE), B

          $(CSTORE), C

          $(DSTORE), D

          $(ESTORE), E

      ];

       

      The values for dr_acct in the load inline table (eg. $(ASTORE)) references the values in [DR ACCT] in the main load table, therefore the values in dr_acct and [DR ACCT] are the same, just that they have different variable names. So how can I make my OGL table to have these variables?:

       

      OGL
      PO_num
      DATE
      [DR ACCT]
      DR
      PRICE
      dr_acct
      STORE

       

      Thanks.