Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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.

Community Browser