topic load distinct value from database! in QlikView

load distinct value from database!

sushovan93 — Mon, 26 Feb 2018 22:17:41 GMT

I have a data like

ID	Name	Vendor	Sub Contractor	Role	Hours	Shift
348765	Sovan,Mandal	DEF	ABC	XYZ	12.2	NS
348765	Shovan,Mandal	DEF	ABC	XYZ	12.2	NS

in HANA table, how can i load only one data into my QlikView QVD?

I need to load only

348765

Shovan,Mandal

DEF

ABC

XYZ

12.2

Please any one help me with this,

Thanks in advance for the help.

i tried:

SQL: Select distinct(ID),

name,.....,

from table.

Unfortunately it did not work.

Re: load distinct value from database!

juraj_misina — Mon, 26 Feb 2018 22:25:13 GMT

Hi,

I can't advise on SQL, but I can advise on Qlik and what you can do is

LOAD

ID,

FirstSortedValue(Name) as Name,

Vendor,

...

Group By

ID,

Vendor,

...

;

SQL Select * from table;

Unfortunately, there's no function such as ChooseCorrectValueFromThisPileOfRandomCrap(FieldName) so you might not get THE value, but you will only get one distinct record.

Hope this helps

Juraj

Re: load distinct value from database!

a_mullick — Tue, 27 Feb 2018 15:59:26 GMT

Hi,

If the rows are exactly the same, then DISTINCT should work fine. Perhaps try without the brackets around 'ID'.

Here's a tutorial:

https://www.w3resource.com/sql/select-statement/queries-with-distinct-multiple-columns.php

Thanks,

Azam

Re: load distinct value from database!

sushovan93 — Tue, 27 Feb 2018 20:10:12 GMT

Hi Azam,

Thanks for the help,

I tried with distinct, with and without the bracket.

but it did not work.

Thank you very much

Re: load distinct value from database!

a_mullick — Wed, 28 Feb 2018 10:07:43 GMT

That suggests that the rows are unique then. Looking at the example you posted, I notice that the first line has 'Sovan', and the 2nd has 'Shovan' in the name field. I know that the example may not be real data, but a DISTINCT would 'fail' in that query.

Azam