Load and Join table

Mon, 14 Feb 2011 02:20:33 GMT

HI All,

I would like to ask a question regarding joining 2 tables.

here is my script :

first tab:

[GLPCT]:

// EC-PCA: Totals Table

Load

[RRCTY]

[RYEAR]

[DRCRK]

[RBUKRS]

[RACCT]

[RPMAX]

[RASSC]

[HSLVT]

[HSL01]

[HSL02]

[HSL03]

[HSL04]

[HSL05]

[HSL06]

[HSL07]

[HSL08]

[HSL09]

[HSL10]

[HSL11]

[HSL12]

[HSL13]

[HSL14]

[HSL15]

[HSL16]

;

SQL

from GLPCT WHERE RYEAR = 2011 AND RBUKRS = 6700

;

Select RRCTY RYEAR DRCRK RBUKRS RACCT RPMAX HSLVT HSL01 HSL02 HSL03 HSL04 HSL05 HSL06 HSL07 HSL08 HSL09 HSL10 HSL11 HSL12 HSL13 HSL14 HSL15 HSL16 RASSC

STORE

GLPCT.QVD;

my 2nd tab is :

* FROM [GLPCT] INTO as [In company code currency_HSL16] as [In company code currency_HSL15] as [In company code currency_HSL14] as [In company code currency_HSL13] as [In company code currency_HSL12] as [In company code currency_HSL11] as [In company code currency_HSL10] as [In company code currency_HSL09] as [In company code currency_HSL08] as [In company code currency_HSL07] as [In company code currency_HSL06] as [In company code currency_HSL05] as [In company code currency_HSL04] as [In company code currency_HSL03] as [In company code currency_HSL02] as [In company code currency_HSL01] as [In company code currency_HSLVT] as [Trading Partner_RASSC] as [Period_RPMAX] as [Account Number_RACCT] as [Company Code_RBUKRS] as [Debit/Credit Ind._DRCRK] as [Fiscal Year_RYEAR] as [Record Type_RRCTY]

[CSKU]:

// Cost Element Texts

Load

[SPRAS]

[KTOPL]

[LTEXT]

[KSTAR]

as [Cost Element_KSTAR],

[KTEXT]

as [Name_KTEXT];

SQL

where SPRAS ='EN' and KTOPL ='FLDA'

;

Select SPRAS KTEXT KTOPL LTEXT KSTAR from CSKU

STORE

* FROM [CSKU] INTO CSKU.QVD; as [Description_LTEXT], as [Chart of Accounts_KTOPL], as [Language Key_SPRAS],

how do i join GLPCT and CSKU if my SQL syntax looks like this :

CSKU INNER JOIN
GLPCP ON CSKU.KSTAR = GLPCP.RACCT

thanks....

Load and Join table

Mon, 14 Feb 2011 03:00:21 GMT

Hi,

I think the alignment has been disturbed while you posted your code in this post.

What you can do is first load your first table CSKU as follows:-

CSKU:

LOAD *,

KSTAR as KEY;

SQL

<Your select statement> ;

then load your second table GLPCP as follows:-

INNER JOIN (CSKU)

LOAD *,

RACCT as KEY;

SQL

<Your select statement>;

This way you will get the required result.

Thanks & Best Regards,

Kuldeep Tak

Load and Join table

Mon, 14 Feb 2011 03:37:45 GMT

Thank you very much...it works!

topic Load and Join table in QlikView

Load and Join table

Load and Join table

Load and Join table