Right Join

[upaliwije]

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

[Anonymous]

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.

[raghvendrasingh]

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

[gautik92]

instead load the cross table first and use left join

[jagan · Accepted solution]

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.

[Kushal_Chawda]

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;