Select rows from a datset based on Date
I have a dataset with one column as Date. Now I want to create an ETL process to create a new Dataset from the existing one based on rows which correspond top 10 days in the Date column of the existing data.
I checked on the available options for ETL but failed to see any direct way to do this. Only option that is close to my issue is to select a particular day from date-selector or to select the current day - which is not exactly what I wanted.
Is there any way to create a dataset based on only top few days in the existing one?