LOAD data into QlikView

[pgarcia75]

Hello

I have a MySQL table with the following lines:
1;2019-02-16 11:30; a; b; c; S12
2;2019-02-16 12:25; x; y; z; S12
1;2019-02-16 12:50; a; b; c; S14
3;2019-02-16 14:05; d; e; f; S12

that I charge with the instruction:

RDV:
LOAD
    idRdvUniqe, // no,
    dateRdv // Date of appointment
    ipp,
    nomPat,
    prenomPat,
    typeMsg;
SQL SELECT *
FROM hl7.S12;

This instruction loads the table completely.

Each line has a unique identifier (idRdvUniqe), and I would like to load in QLICKVIEW the
last updated line.

In my example, I would like to load:
2;2019-02-16 12:25; x; y; z; S12
1;2019-02-16 12:50; a; b; c; S14
3;2019-02-16 14:05; d; e; f; S12
 
How can I do ?

Thank you

PG

[rahulpawarb]

Please add below code snippet to the script:

INNER JOIN (RDV)

LOAD

idRdvUniqe,

Max(dateRdv) AS dateRdv

Resident RDV

Group By idRdvUniqe;

[pgarcia75]

Thansk for all