data analysis, DATE TIME FIELD. GROUPING AGGREGRATION

[happyfeet11]

Dear Friends

 I am in a big fix and have been spending days to figure out few things in qliksense.

i have the folowing table :

and the result should be each mode type and id 

id        date_time         mode   mode_start      mode _endtime

can you please help here urgently

best

ïndrani

[anat]

can u try like below:

tab:
load * inline [
date,mode
01/12/2021,A
01/12/2021,B
04/12/2021,A
02/12/2021,B
05/12/2021,A
06/12/2021,B
];

t2:
load mode,date(min(date)),date(max(date)) resident tab group by mode;

[happyfeet11]

Hi sorry what happens if the datefields are different for each field. see column 1