Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QlikCommunity
I have a dataset with project names and deadline dates. Some projects have multiple deadline dates. I am only interested in the oldest date. My question is, how do I filter out the remaining dates in the script so I only load one deadline date pr. project?
This is how it could look. I have highlighted the dates that needs to be loaded in if a project has multiple values.
Any help is appreciated
Casper
Data_temp:
load
Project_name,
"Deadline Date"
from Yoursource;
left join load
Project_name,
min("Deadline Date") as MinDate
resident Data_temp
group by Project_name:
Data:
load
Project_name,
"Deadline Date"
resident Data_temp
where "Deadline Date" = MinDate;
drop table Data_temp;
regards
Data_temp:
load
Project_name,
"Deadline Date"
from Yoursource;
left join load
Project_name,
min("Deadline Date") as MinDate
resident Data_temp
group by Project_name:
Data:
load
Project_name,
"Deadline Date"
resident Data_temp
where "Deadline Date" = MinDate;
drop table Data_temp;
regards