Concatenate on resident table

[francisvandergr]

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;

[prieper]

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

[nagaiank]

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;

[#4]

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