topic Concatenate on resident table in QlikView

Concatenate on resident table

francisvandergr — Mon, 06 Jun 2011 19:51:19 GMT

I have a question. Script below doesn't work. I have a table what is called Sales. In the second part of the script i wanna load only records (FACTUUROPDRACHT) which are not in the first part of the script. The problem is that i see no records from the second part. Do anyone know a reason ?

Sales:
LOAD FACTUUROPDRACHT,
    CDDEBITEUR,
    OPDRACHTDATUM,
    CDARTIKEL,
    OMSCHR,
    DATUM,
    '1' as Part

Resident Factuuropdracht60100 WHERE CDARTIKEL='60.100' ORDER BY FACTUUROPDRACHT;
drop table Factuuropdracht60100;

Concatenate load
    FACTUUROPDRACHT,
    CDDEBITEUR,
    OPDRACHTDATUM,
    CDARTIKEL,
    OMSCHR,
    DATUM,
     '2' as Part

Resident Factuuropdracht60300 where not exists (FACTUUROPDRACHT);
drop table Factuuropdracht60300;

Concatenate on resident table

prieper — Mon, 06 Jun 2011 19:57:11 GMT

Hmmm: script seem to be o.k. I always tend to specify JOIN- or CONCATENATE-commands, so try with CONCATENATE (Sales) LOAD ....

If the Factuuropdracht60300-table has the same format, the script will concatenate to this table and will be deleted.

HTH
Peter

Re: Concatenate on resident table

nagaiank — Mon, 06 Jun 2011 20:16:28 GMT

Try the following and see if it works.

Sales:

NoConcatenate
LOAD FACTUUROPDRACHT,
    CDDEBITEUR,
    OPDRACHTDATUM,
    CDARTIKEL,
    OMSCHR,
    DATUM,
    '1' as Part

Resident Factuuropdracht60100 WHERE CDARTIKEL='60.100' ORDER BY FACTUUROPDRACHT;
drop table Factuuropdracht60100;

Concatenate load
    FACTUUROPDRACHT,
    CDDEBITEUR,
    OPDRACHTDATUM,
    CDARTIKEL,
    OMSCHR,
    DATUM,
     '2' as Part

Resident Factuuropdracht60300 where not exists (FACTUUROPDRACHT);
drop table Factuuropdracht60300;

Concatenate on resident table

Tue, 07 Jun 2011 02:29:53 GMT

Krishnamoorthy is right. QlikView is automatically concatenating the tables because all the fields are named the same.