Remove duplicate rows

[Hasan]

Hi - I have the following in my data load editor:

LOAD Distinct
object,
// attribute,
// value,
DC ,UC ,LA ,ED ,DA ,OR ,CA 
FROM EKES.qvd (qvd);

I need help/guideline to remove dates that are duplicates.

Required Result
4500105786-00010	4/23/2021		4/23/2021	4/23/2021	4/30/2021	4/25/2021	4/30/2021
4500105786-00010	4/28/2021		4/28/2021	4/29/2021			5/4/2021
4500105786-00020	5/6/2021

Thanks so much  - Kashif

[Anil_Babu_Samineni]

I see you have row level data for DC column, Could be that is the reason you have aggregate data. 

If you still don't want, Perhaps try Aggr(Your expression, Dimension)

[Hasan]

Thanks for the reply, how  AGGR function can be used in a load script?

[menta]

Use a group by Object and LA

load object, LA,

 firstsortedvalue(AD,LA) as AD,

same for the other field

resident table

group by object,LA;