Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Hi
try this in a pivot table or straight table
Aggr(max(feedbakdate),confid,userid)
Hi Sunny,
Thanks a lot .It worked
Thanks and Regards,
Nishant Nadkarni