topic Re: Right Join in QlikView

Right Join

upaliwije — Thu, 05 Nov 2015 06:30:13 GMT

I have following script with Right Join

chart:

LOAD GL_CODE,

DESCRIPTION,

GROUP_CODE,

NOTE,

GLA_PRODUCT_CLASS

FROM

[..\..\Qlikview\QVD\Master_table\ACC_MASTER.qvd]

(qvd);

Right join(chart)

CrossTable(MONTH, AMOUNT, 3)

LOAD DB,

GLCODE,

DESCRIPTION,

[1_D],

[1_C],

[2_D],

[2_C]

FROM

CHART_OF_ACCOUNTS.xls

(biff, embedded labels, table is CICCO_TB$);

But It is giving following error message when data is loaded

Illegal combination of prefixes

Right join(chart)

CrossTable(MONTH, AMOUNT, 3)

LOAD DB,

GLCODE,

DESCRIPTION,

Pls help me to correct this

Re: Right Join

Anonymous — Thu, 05 Nov 2015 06:35:36 GMT

CrossTable(MONTH, AMOUNT, 3)

Chart:

LOAD DB,

GLCODE,

DESCRIPTION,

[1_D],

[1_C],

[2_D],

[2_C]

FROM

CHART_OF_ACCOUNTS.xls

(biff, embedded labels, table is CICCO_TB$);

left join(chart)

LOAD GL_CODE as GLCODE,

DESCRIPTION,

GROUP_CODE,

NOTE,

GLA_PRODUCT_CLASS

FROM

[..\..\Qlikview\QVD\Master_table\ACC_MASTER.qvd]

(qvd);

Try this one.

Re: Right Join

raghvendrasingh — Thu, 05 Nov 2015 06:47:07 GMT

Hi,

Could you please provide the qvw in which you are performing the operations, because when i make this scenario then it will take time.

One more suggestion you can take resident load of 2nd table and then make right join.

Regards,

Raghvendra

Re: Right Join

gautik92 — Thu, 05 Nov 2015 06:49:17 GMT

instead load the cross table first and use left join

Re: Right Join

jagan — Thu, 05 Nov 2015 07:11:33 GMT

Hi,

Try like this, you cannot use join & concatenate in a single shot

chart:

LOAD GL_CODE,

DESCRIPTION,

GROUP_CODE,

NOTE,

GLA_PRODUCT_CLASS

FROM

[..\..\Qlikview\QVD\Master_table\ACC_MASTER.qvd]

(qvd);

Accounts:

CrossTable(MONTH, AMOUNT, 3)

LOAD DB,

GLCODE,

DESCRIPTION,

[1_D],

[1_C],

[2_D],

[2_C]

FROM

CHART_OF_ACCOUNTS.xls

(biff, embedded labels, table is CICCO_TB$);

Right join(chart)

LOAD

FROM Accounts;

DROP TABLE Accounts;

Hope this helps you.

Regards,

jagan.

Re: Right Join

Kushal_Chawda — Thu, 05 Nov 2015 07:34:35 GMT

You cannot use Join over Cross table directly. First You need to take resident of Cross table Data then join with table

chart:

LOAD GL_CODE,

DESCRIPTION,

GROUP_CODE,

NOTE,

GLA_PRODUCT_CLASS

FROM

[..\..\Qlikview\QVD\Master_table\ACC_MASTER.qvd]

(qvd);

Accounts:

CrossTable(MONTH, AMOUNT, 3)

LOAD DB,

GLCODE,

DESCRIPTION,

[1_D],

[1_C],

[2_D],

[2_C]

FROM

CHART_OF_ACCOUNTS.xls

(biff, embedded labels, table is CICCO_TB$);

right join (chart)

load *

Resident Accounts;

Drop table Accounts;