topic Re: Help Inner Join Load in QlikView

Help Inner Join Load

Thu, 19 Jan 2012 12:48:31 GMT

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

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

Re: Help Inner Join Load

nstefaniuk — Thu, 19 Jan 2012 13:17:33 GMT

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;

Re: Help Inner Join Load

Fri, 20 Jan 2012 08:00:46 GMT

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