Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Help Inner Join Load

Hello!

I am trying to make a join between the 'percentage_bsclsku' (Tab Brut Sales Percentages) and the 'aaa' table (Tab Brut Sales). Whenever I put the join it gives strange error as Table NOT FOUND. Where I am going wrong?

I have attached the qvw file.  Can someone help me?

Thank you.

Regards

Marian T

===========================================================

Tags (3)
1 Solution

Accepted Solutions
nstefaniuk
Contributor III

Re: Help Inner Join Load

Hi.

Use NoConcatenate Load instead of Load if you want to create a table bbb which is a subset of a resident table, without new column.

bbb:
NoConcatenate LOAD
    bsclsku_an,
    bsclsku_luna,
    bsclsku_kanal,
    bsclsku_client,
    bsclsku_sku,
    bsclsku_sku_amt,
    bsclsku_cl_amt
RESIDENT percentage_bsclsku;

2 Replies
nstefaniuk
Contributor III

Re: Help Inner Join Load

Hi.

Use NoConcatenate Load instead of Load if you want to create a table bbb which is a subset of a resident table, without new column.

bbb:
NoConcatenate LOAD
    bsclsku_an,
    bsclsku_luna,
    bsclsku_kanal,
    bsclsku_client,
    bsclsku_sku,
    bsclsku_sku_amt,
    bsclsku_cl_amt
RESIDENT percentage_bsclsku;

Not applicable

Re: Help Inner Join Load

Thanks nstefaniuk! That's what i expected. Many thanks again

Community Browser