EXCLUSIONES/EXCLUSIONS

[#1]

Dears,

     Need your help to know how I can work with two documents where on one of them I have the inventory and the second one has information where some of the data is the same as the first one and I want to delete them. Thanks.

Estimados,

     Requiero de su ayuda para saber cómo puedo trabajar con dos documentos en donde uno de ellos tengo el inventario y en el segundo tiene información igual al primera y quiero eliminarla. Gracias.

Saludos

Regards

[JonnyPoole]

Do you mean you don't want to load the duplicate data from the 2nd file if it already has been loaded from the first ?

I would suggest using the exists() function

Data:

Load

     Key,

     <data>

from file1

concatenate (Data)

Load

     Key,

     <data>

from file2

where not exists(Key);

[hemhund2016]

Hi,

You can do a partial reload of second document and drop the tables that you don't want.

Thanks,

Hemanth.