topic Re: load no duplicate in QlikView

load no duplicate

upaliwije — Sat, 01 Aug 2015 15:44:48 GMT

I have created a QVD file where duplicate records also exits

Fields

Policy No

Vehicle Type

I want only to load distinct records to QV document. How can I control it in my load syntax. Pls help

Re: load no duplicate

swuehl — Sat, 01 Aug 2015 15:52:46 GMT

Have you tried

LOAD DISTINCT

[Policy No],

[Vehicle Type]

FROM YourQVD.qvd (qvd);

Re: load no duplicate

qlikviewwizard — Sat, 01 Aug 2015 15:55:26 GMT

Hi,

Please use the script below:

Data:

LOAD distinct Policy No , Vehicle Type

FROM Table;

Hope this will help you.

Re: load no duplicate

sasiparupudi1 — Sat, 01 Aug 2015 17:10:17 GMT

tab1:

LOAD

[Policy No],

[Vehicle Type]

Inline

[

Policy No,Vehicle Type

1234,Sedan

2345,SUV

9345,XUV

8907,Sports

];

NoConcatenate

tab2:

LOAD [Policy No],[Vehicle Type],

if((Previous([Vehicle Type])=[Vehicle Type] and Previous([Policy No])=[Policy No]),1,0) as DupFlag

Resident tab1

order by [Policy No],[Vehicle Type];

drop Table tab1;

tabNoDups:

NoConcatenate

LOAD * Resident tab2 where DupFlag=0;

drop Table tab2;

Re: load no duplicate

sunny_talwar — Sat, 01 Aug 2015 19:40:22 GMT

I think instead of running through the script you suggest, why not just do this:

tab1:

LOAD Distinct [Policy No],

[Vehicle Type]

Inline

[

Policy No,Vehicle Type

1234,Sedan

2345,SUV

9345,XUV

8907,Sports

];

Is there a reason you choose your method over this?? I always fail to understand how exactly Distinct works the script, so wondering if there are cases you know where DISTINCT may or may not work??

Thanks,

Sunny

Re: load no duplicate

sasiparupudi1 — Sat, 01 Aug 2015 19:49:54 GMT

no special reason..I thought, if he wanted to see the duplicate records, he could do so with my script.

Re: load no duplicate

sunny_talwar — Sat, 01 Aug 2015 19:51:49 GMT

Got it

Thank you

Re: load no duplicate

qlikviewwizard — Sun, 02 Aug 2015 04:51:26 GMT

Hi,

Please close the thread by selecting Correct Answer. Thank you.