topic Re: Removing duplicate data from different tables in QlikView

Removing duplicate data from different tables

Anonymous — Tue, 07 Oct 2014 10:30:11 GMT

Hi guys.

I have two tables

Salesman 1

Sales_amount

‘Salesman1’ as Salesman

Salesman 2

Sales_amount

‘Salesman2’ as Salesman

There is a chance that someone might apply via more than one salesman. For example they go to Salesman2 to make their original application and then realise they have made a mistake and go to Salesman1 to apply again.

I’d like to identify anyone who appears in more than one table and remove them from the Salesman1 table. Can this be done?

Re: Removing duplicate data from different tables

deepakqlikview_123 — Tue, 07 Oct 2014 10:34:15 GMT

Can you please expalin what u want exactly.

f u want to just calcu8lation use distinct clause

eg for counting distinct records count( distinct value).

Thanks

Re: Removing duplicate data from different tables

anbu1984 — Tue, 07 Oct 2014 10:38:04 GMT

Salesman2:

Load PIN,Sales_amount,‘Salesman2’ as Salesman From Salesman2;

NoConcatenate

Salesman1:

Load PIN, Sales_amount, ‘Salesman1’ as Salesman From Salesman1 Where Not Exists(PIN);