Combining mapping load from xls and load from sql

Fri, 12 Sep 2014 09:21:11 GMT

Good morning,

I want to combine a mapping load from xls and a load from sql and run into probs with syntax. Below script results in an error message "field GL_AccountDebit.GLACCT_D unknown" - what is the right syntax?

Directory;
AccountsD:
mapping LOAD
[G/L Account.SAKNR] as GL_AccountDebit.GLACCT_D,
[Long Text.TXT50] as LongText.TXT50_D
FROM
skat.XLS
(txt, unicode, embedded labels, delimiter is '\t', msq);

CONNECT TO SAPdb;
RevAllocTable:
load

.... {many fields}

GLACCT_D as GL_AccountDebit.GLACCT_D,

.... {many more fields}

PSTNR as RA_PostingNumber.PSTNR,
ApplyMap ('AccountsD', GL_AccountDebit.GLACCT_D, 'Not Populated') as GL_Name;
select * from SAPdb.SAP."ZFI_RA_POST";

Re: Combining mapping load from xls and load from sql

MK_QSL — Fri, 12 Sep 2014 09:22:36 GMT

Try

ApplyMap ('AccountsD', GLACCT_D , 'Not Populated') as GL_Name;

topic Re: Combining mapping load from xls and load from sql in QlikView

Combining mapping load from xls and load from sql

Re: Combining mapping load from xls and load from sql