topic Re: Load only Unique records in QlikView

Load only Unique records

rjn — Tue, 01 Mar 2016 10:24:59 GMT

Hi,

I am trying to load only the unique rows from a QVD. The first record from duplicate records should load, 2nd or any following duplicate rows should be ignored.

below is the example I am trying, please help.

QVD

Name	ID
ABC	666
ABC	444
XYZ	111
KKK	333

Output excepted:

Name	ID
ABC	666
XYZ	111
KKK	333

Regards,

J. Ravichandra Kumar

Re: Load only Unique records

sunny_talwar — Tue, 01 Mar 2016 10:26:50 GMT

Try this:

LOAD Name,

First(ID) as ID

FirstValue(ID) as ID

FROM QVD

Group By Name;

Re: Load only Unique records

puttemans — Tue, 01 Mar 2016 10:28:17 GMT

Load Distinct?

LOAD DISTINCT

Name,

FROM source;

Re: Load only Unique records

Chanty4u — Tue, 01 Mar 2016 10:28:29 GMT

sample:

load *

distinct

FROM ur datasource;

Re: Load only Unique records

tresB — Tue, 01 Mar 2016 10:29:26 GMT

LOAD Name,

FirstValue(ID) as ID

FROM QVD

Group By Name;

Re: Load only Unique records

Anonymous — Tue, 01 Mar 2016 10:30:02 GMT

Load

ID ,

Name

from QVD

where not exists([Name)] ;

Re: Load only Unique records

sunny_talwar — Tue, 01 Mar 2016 10:31:20 GMT

Hahahaha thanks for pointing that out tresesco‌‌, I realized it just after posting it

Re: Load only Unique records

MayilVahanan — Tue, 01 Mar 2016 10:32:54 GMT

Try like this

LOAD Name,

FirstValue(ID) as ID

FROM Yoursourcetable

Group By Name;