Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Hasan
Contributor
Contributor

Remove duplicate rows

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.

Hasan_0-1627469549898.png

Required Result       
4500105786-000104/23/2021 4/23/20214/23/20214/30/20214/25/20214/30/2021
4500105786-000104/28/2021 4/28/20214/29/2021  5/4/2021
4500105786-000205/6/2021      

 

 

Thanks so much  - Kashif

3 Replies
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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Hasan
Contributor
Contributor
Author

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

menta
Partner
Partner

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;