Get Max Dates Row

[qlikwiz123]

My data has 6 columns

Data1, Data2, Data3, Data4, Start Date, End Date

Data1	Data2	Data3	Data4	Start Date	End Date
ASA	Genuine	A	q	1/24/2021	1/31/2022
Origin	Vesa	A	e	4/5/2021	3/25/2023
ASA	Part	B	a	7/8/2020	11/9/2022
ASA	Pilar	G	f	9/10/2021	12/20/2023
ASA	Standard	v	u	5/1/2021	2/3/2022
Origin	Basement	y	u	8/3/2021	9/22/2022
Origin	Pillar	u	e	10/26/2020	12/19/2024
Origin	Construct	c	r	4/15/2021	4/16/2022

I want to create an output with only Maximum Dates per Data1 value as below

Data1	Start Date	End Date
ASA	9/10/2021	12/20/2023
Origin	8/3/2021	12/19/2024

[MarcoWedel]

maybe just a straight table with Data1 as dimension and two expressions Max(StartDate) and Max(EndDate) ?

[Vegar]

As @MarcoWedel wrote, it is easy to achieve in front end using max(...Date). 

I noticed tat you have taggad your question with "Scripting". If you want to achieve this in the load script then ut would look like this.

Load Data1, 

Max(StartDate) as StartDate ,

Max(EndDate) as EndDate

Resident [Your Data]

Group By [Data1];