LOAD data into QlikView

pgarcia75 — Sat, 16 Nov 2024 04:25:26 GMT

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

Re: LOAD data into QlikView

rahulpawarb — Mon, 18 Feb 2019 09:30:42 GMT

Please add below code snippet to the script:

INNER JOIN (RDV)

LOAD

idRdvUniqe,

Max(dateRdv) AS dateRdv

Resident RDV

Group By idRdvUniqe;

Re: LOAD data into QlikView

pgarcia75 — Fri, 22 Feb 2019 10:46:22 GMT

Thansk for all

topic LOAD data into QlikView in QlikView

LOAD data into QlikView

Re: LOAD data into QlikView

Re: LOAD data into QlikView