How to load distinct ID's

[Anonymous]

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

[tresesco]

Select Distinct ID From <>;

[Anil_Babu_Samineni]

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

[avinashelite]

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

[mahendragaur]

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

[Anonymous]

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;