Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

EXCLUSIONES/EXCLUSIONS

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

2 Replies
Employee
Employee

Re: EXCLUSIONES/EXCLUSIONS

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
Contributor

Re: EXCLUSIONES/EXCLUSIONS

Hi,

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

Thanks,

Hemanth.

Community Browser