Help Inner Join Load

[#1]

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

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

[nstefaniuk · Accepted solution]

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;

[#3]

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