topic Re: How to load distinct ID's in QlikView

How to load distinct ID's

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

My data Looks Like Below

ID, Country

1, India

1, USA

want load distinct ID's in qlikview data sourcing from SQL in single table

Thanks ,

nagesh

Re: How to load distinct ID's

tresB — Thu, 30 Mar 2017 07:11:39 GMT

Select Distinct ID From <>;

Re: How to load distinct ID's

Anil_Babu_Samineni — Thu, 30 Mar 2017 07:26:22 GMT

In fact, If all tabular has same values it will take automatic, That's the power of Qlik. Here, I am not sure what are you expecting. May be Pivot from UI prospect. Or can you share few rows and expected one which demonstrates the issue

Re: How to load distinct ID's

avinashelite — Thu, 30 Mar 2017 07:28:10 GMT

If you want to load Distinct on ID, Country then it would yield same result as above ..

if you need only ID then follow Tresesco approach

Re: How to load distinct ID's

mahendragaur — Thu, 30 Mar 2017 11:26:04 GMT

Could you please share your expected output? That'll be better to understand what you exactly require.

Re: How to load distinct ID's

Anonymous — Fri, 31 Mar 2017 08:36:50 GMT

Got Solutions hence closing this ticket

MYNEWDATA:

Load *

Resident MYDATA Order by ID;

Drop table MYDATA;

NoConcatenate

DuplicatesRemoved:

Load *

Resident MYNEWDATA

Where Peek(ID)<>ID;

drop table MYNEWDATA;