topic Re: LOAD in QlikView

LOAD

Tue, 27 Nov 2012 09:31:01 GMT

Hi all,

from a table with the following structure i need to extract only one record per value of a certain field.

Table:

What i want: For each value in A and C i want to extract ONE record (no matter which record). The result could look something like this:

Hope, my problem is clear & thanks a lot for some advise.

regards.K

Anonymous — Tue, 27 Nov 2012 09:38:05 GMT

Something like this:

LOAD

minstring(B) as B,

FROM

DATASOURCE

group by A, C;

jagan — Tue, 27 Nov 2012 09:38:56 GMT

Hi,

Try this

LOAD

Max(B) AS B

FROM DataSource

GROUP BY A, C;

Regards,

Jagan.

Tue, 27 Nov 2012 11:12:01 GMT

it ll work fine.