Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
Hi,
You can do a partial reload of second document and drop the tables that you don't want.
Thanks,
Hemanth.