Qlik sense

[madhun]

Separation:
LOAD
employee_code,
last_available_date,
separation_status
FROM [lib://Test/hrmv_emp_sep_hdr.xlsx]
(ooxml, embedded labels, table is Sheet1);

i Want  a sepatare Table 
with Only distinct {last_available_date} along with thair employee_code

[Benoit_C · Accepted solution]

Hello @madhun,

If you want a separate table with only distinct last_available_date and employee_code, you can use the DISTINCT keyword in your LOAD statement. For example:

DistinctDateTable: LOAD DISTINCT employee_code, last_available_date FROM [lib://Test/hrmv_emp_sep_hdr.xlsx] (ooxml, embedded labels, table is Sheet1);

This will create a new table called DistinctDateTable with only the unique combinations of employee_code and last_available_date from your source data.

Regards,
Benoit

[vinieme12]

as below

Separation:
LOAD
employee_code,
last_available_date,
separation_status
FROM [lib://Test/hrmv_emp_sep_hdr.xlsx]
(ooxml, embedded labels, table is Sheet1);

LatestDate:

LOAD
employee_code,
Date(Max(last_available_date)) as latest_date,
Resident temp

Group by employee_code;