Load problem

[#1]

Hi, I have this problem that I dont know how to load this.

LOAD EMP,

     P_DATE,

     P_TIME, 

     P_TYPE

FROM

*****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1;

this gets this:

I only want to show the min P_TIME.

So i want to add "AND P_TIME minimum value"

Hope u understand me?!

[alexandros17]

A chart, with dimension and expression

[alexandros17]

Otherwise (if you don't need other values you could:

MYTAB_TMP:

LOAD EMP,

     P_DATE,

     P_TIME,

     P_TYPE

FROM

*****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1;

Inner join

Load EMP,P_DATE, min(P_TIME) as P_TIME

from

...

where

...

Group by EMP,P_DATE;

In this way you can use a table too, having only minimum values

[Anonymous]

Try below,

LOAD EMP,

     P_DATE,

     P_TYPE,

     Min(P_TIME) as P_TIME

FROM

*****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1

GROUP BY EMP, P_DATE, P_TYPE;

[#5]

Hi,

Did u try adding another condition to your existing query, like below;

LOAD EMP,

     P_DATE,

     P_TIME,

     P_TYPE

FROM

*****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1

AND P_TIME=MIN(P_TIME);

Regards.