join load inline variables to main data load

Fri, 10 Oct 2014 02:50:51 GMT

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.

topic join load inline variables to main data load in QlikView

join load inline variables to main data load