Max Date rating logic

[Anonymous]

Hi All,

I have a table with following columns

confid ,

userid,

feedbakdate,

rating

What i wish to achieve is for a given conference should have only one rating per user .

In the current scenario  one user can give multiple rating for a single conference.

I need to pick only the latest of all ratings given by the same user  as per the latest date.

Please help me with the logic.

Thanks and Regards,

Nishant Nadkarni

[sunny_talwar · Accepted solution]

May be like this:

Table:

LOAD confid ,

          userid,

          feedbakdate,

          rating,

          DateField

FROM Source....

Right Join (Table)

LOAD confid,

          userid,

          Max(DateField) as DateField

Resident Table

Group By confid, userid;

[Anonymous]

Hi

try this in a pivot table or straight table

Aggr(max(feedbakdate),confid,userid)

[Anonymous]

Hi Sunny,

Thanks a lot .It worked

Thanks and Regards,

Nishant Nadkarni