DISTINCT values

[#1]

Hi all,

I have a scenario where I need to compute for my Days Delayed. Problem is when i sum up my DaysDelayed some are doubled,tripled, and so on. That is because I have records that are distinct but have the same dates to compute days delayed. Are there ways to distinct this without the use of removing the other fields to clasify it as distinct? it's like, I only need to get the 1st record out of n records. If there are 4 distinct records that have the same ID,Dates i need to compute for days delayed, and all other fields are distinct, I need to count that as 1 record so I can use the AVG function.

Thanks,

Donna

[sushil353]

I guess, U can use group by function while loading the data and then join the table. it will work like this:

     1. get the id for max or min value and groupby id.. store this in temp table

2. after that make a left or right join to get the distinct records.

For more understanding please upload some sample data..

Regards,

Sushil

[#3]

Hi,

  Can you upload the samle App