topic load (distinct) help needed! in QlikView

load (distinct) help needed!

Mon, 08 Jun 2009 23:31:35 GMT

Hi guys,

Just a quick question. I wish to load only distinct records so I therefore thought (after looking at the manual) that putting eg

LOAD

DISTINCT(field),

field2....etc

from......

would work? This is not the case. Anyone wish to shed some light?

Thanks for the help!

load (distinct) help needed!

Anonymous — Mon, 08 Jun 2009 23:34:45 GMT

LOAD distinct
field,
field2,
...
From...;

load (distinct) help needed!

Mon, 08 Jun 2009 23:39:50 GMT

I thought it was too easy to be true 🙂

Thanks for help...

load (distinct) help needed!

Tue, 09 Jun 2009 16:26:12 GMT

Actually sorry,

That didn't seem to work.

I have a table with ProblemID and a list of other fields. There are Problem Id's with the same Id. The only way in that they differ is the end date. I am only looking to display the ProblemId with the most recent end date. Is this possible?

Regards,

load (distinct) help needed!

Tue, 09 Jun 2009 17:29:24 GMT

ya try peek(endday) or Previous(endday) must solve your problem according to your use.

load (distinct) help needed!

Tue, 09 Jun 2009 17:37:14 GMT

Try

LOAD

ProblemID,

MAX(EndDate)

From.......

GROUP BY ProblemID;

Regards,

Joao

load (distinct) help needed!

Tue, 09 Jun 2009 17:42:13 GMT

Add a Right Join too,

Right Join ( OriginalTable)

Load ProblemID,Max(EndDate) as EndDate

Resident OriginalTable

Group By ProblemID;

This should exclude all the other records, and will keep only one record per problemID