Loading all the Data

Anonymous — Thu, 12 Jul 2018 14:18:29 GMT

Good Morning;

I hope I will explain this correctly

I have successfully loaded my data via the script below however I only appear to be getting data where both agree.

I was under the impression that doing the AutoNumberHash would allow me to create a key that would then allow for all my data from the left (GL Information) to come in and then the right item (Voucher Information) would come in where it matches. So far I get the data that is equal to both side. Am I loading this statement correctly?

[GL Information]:

LOAD

AutoNumberHash256 ([Acct ID], ID, [FY Cd], [Pd No]) AS [%GL_Vchr],

[Company ID],

[%GL-Detl-Key],

[Vchr No],

[ID Type],

[PO ID],

[Invc ID],

[Detl Amt],

[Trn Desc],

ID,

Name,

[Acct ID] AS [Account ID],

[Org ID] AS [Organization ID],

ApplyMap ('OrganizationMap', [Org ID], [Org ID]) as [GL Org Name],

[Proj ID] AS [Project ID],

ApplyMap ('ProjectMap', [Proj ID], [Proj ID]) as [GL Proj Name],

[FY Cd],

[Pd No],

[Subpd No],

[Jnl Cd]

FROM

[..\VSE KPI\Costpoint\GLDetl-with-Keys.qvd] (qvd)

WHERE

[FY Cd] >= $(vFromYear) AND Wildmatch(left([Org ID], 3), 'V.J') = 0 ;

right join

[Account Category]:

LOAD

ACCT_ID AS [Account ID],

ACCT_NAME AS [Account Name],

ACCT_SUP_TYPE AS [Account Category]

FROM

[..\VSE KPI\Costpoint\XT_ACCOUNT.qvd] (qvd)

WHERE ACCT_SUP_TYPE <> 'eliminate' ;

[Voucher Information]:

LOAD

AutoNumberHash256 (ACCT_ID, VEND_ID, FY_CD, PD_NO) AS [%GL_Vchr],

VCHR_KEY,

VCHR_LN_KEY,

VCHR_LN_NO,

VCHR_LN_DESC,

VEND_ID,

PAY_VEND_ID,

VCHR_NO,

INVC_ID,

FY_CD,

PD_NO,

SUB_PD_NO,

ORG_ID,

ACCT_ID,

CST_AMT

FROM

[..\VSE KPI\Costpoint\CUMVOUCHER.qvd] (qvd);

topic Loading all the Data in QlikView

Loading all the Data