Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
RogerG
Creator
Creator

load one unique value of each category

Hello all,

I would like to retrieve one and only one value for each of the following records, regardless of duplicates.

The criteria is the ID and the minimum date

load * inline [

ID, moddate, activityname, attempt

1,   1/1/2021, ms1, attempt 1

1,   1/1/2021, ms1, attempt 2

1,  1/5/2021, ms2, attempt 3

2,   3/1/2021, ms1, attempt 1

 

so the results would be 

1,   1/1/2021, ms1

2,   3/1/2021, ms2

 

2 Replies
JuanGerardo
Partner - Specialist
Partner - Specialist

Hi @RogerG, I suggest you to use a group by clause:

RawData:

load * inline [

ID, moddate, activityname, attempt

1,   1/1/2021, ms1, attempt 1

1,   1/1/2021, ms1, attempt 2

1,  1/5/2021, ms2, attempt 3

2,   3/1/2021, ms1, attempt 1

];

MyData:

load ID,

Min(Date(moddate)) as moddate

Resident RawData

Group by moddate;

drop table RawData;

 

JG

RogerG
Creator
Creator
Author

Thanks, this project was cancelled on me, sorry for the late response