Load Distinct records

[#1]

Hi,

My client gimme the call data month wise.
If one call ages till next month, it will appear two times - one in previous month and another in current month data.
After loading both months' data, Count(Problem_ID) gives different than that of Count(Distinct Problem_ID).

Instead of writing Distinct in every chart, will it be possible to use the distinct keyword at Load script itself.

I tried like...
Load Distinct Problem_ID,
Problem_Desc,
...,
...;
but its not working.

Any suggestion!!

Thanks & Regards,
Arun Mittal

[prieper · Accepted solution]

Hi,

your script with LOAD DISTINCT ... should solve the problem, provided all the fields other than the key are identical.

If you load from different files using "*", it might be wise to load all the data first and then to review all the data with the DISTINCT-parameter

HTH

Peter

[rwunderlich]

It sounds like you want only the latest record for each Problem_ID. Ensure you load from newest file to oldest file and include the clause

WHERE NOT EXISTS(Problem_ID)

-Rob

[#4]

Thanks Rob

Thanks Peter