Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
===========================================================
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;
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;
Thanks nstefaniuk! That's what i expected. Many thanks again