Resident Load * bug

I’m working on the QlikView combo certification and have noticed this minor bug in the LOAD * RESIDENT syntax.

AcctInvoiceReceiptstxBillingTreat:  
LOAD KEY_MEDNO,Treat.TX,KEY_INVOICE,
KEY_ACCTNUM,Treat.MNAME RESIDENT tab1 ;

If I do the above, a table with the label AcctInvoiceReceiptstxBillingTreat is created.

If I however do a * load then

AcctInvoiceReceiptstxBillingTreat:  
LOAD 
* RESIDENT tab1 ;

The table created is labelled tab1.

This is QlikView 8.5 SR3, so it seems that if you need to duplicate the table, you must explicitly name all fields. If you don't than you'll get 1 duplicate table. What happens is something that QlikTech calls auto concatenation, which automaticly will concatenate any table that has the same field structure.

Their is a quick fix however. Just explicit load 1 colunm, and then but the * next. Then drop it afterwards.

AcctInvoiceReceiptstxBillingTreat:  
LOAD 
KEY_MODNO as BS,* RESIDENT tab1 ;
DROP FIELDS BS;

The table created is labelled correct.

Although I consider this a bug, QlikTech consider this a WAD (work as designed). And to make this work in another way, you can optionally use NOCONCATENATE to stop the auto concatenate  function.

AcctInvoiceReceiptstxBillingTreat:  
NOCONCATENATE LOAD 
* RESIDENT tab1 ;