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.
