Group By

[#1]

hi,

I have applied group by as:

A:

LOAD

     max(ShiftStartDate) as ShiftStartDate,

    max(ShiftEndDate) as ShiftEndDate,

      REF_AgentName,

        REF_acdId

FROM

D:\Qvd\Employee.qvd

(qvd) group by  REF_AgentName,REF_acdId;

Now there are more fields also which I want to fetch.

how can I add fields in table A from same qvd.

Thnks

[sushil353]

you can do a join to this table...with the main table

[#3]

If I am applying join in this than that will affecting my data.

Actually I want to :

REF_acdId according to max(date) only , so that only unique REF_acdId can come.

It is coming by using group by but if I apply join than duplicate REF_acdId is coming.

hope you are understanding the problem.

[Gysbert_Wassenaar · Accepted solution]

Use inner join to keep only records where the fields match in both tables:

LOAD

     max(ShiftStartDate) as ShiftStartDate,

    max(ShiftEndDate) as ShiftEndDate,

      REF_AgentName,

        REF_acdId

FROM

D:\Qvd\Employee.qvd

(qvd) group by  REF_AgentName,REF_acdId;

inner join

load Field1, Field2,....etc

from D:\Qvd\Employee.qvd (qvd);

[sushil353]

Please post the sample data...