Intervalmatch - adding field

Mon, 21 May 2012 16:05:10 GMT

Hi all,

I have the following script that's working fine. The tables are loaded via ODBC connection.

The issue is: in order to add two fields (in bold red) I have to load twice the table. The first time is needed in order to find the correct interval for the DATA_EMISSIONE field. The second load is needed in order to load the 2 fields I am looking for.

Does someone have a smarter/quicker way of doing this? Can I do it in just one load?

Thanks!

[MAIN]:
NULLASVALUE DATA_DECORRENZA_ALQ, DATA_SCADENZA_ALQ;
INTERVALMATCH(DATA_EMISSIONE, NUMCIE, CODICE_GARANZIA)
LOAD DATA_DECORRENZA_ALQ, DATA_SCADENZA_ALQ, NUMCIE, CODICE_GARANZIA where exists(NUMCIE);
SELECT
AL1.NUMCIE,
AL1.GARANT AS CODICE_GARANZIA,
AL1.DATEFF AS DATA_DECORRENZA_ALQ,
AL1.DATCLO AS DATA_SCADENZA_ALQ,
AL1.TAUCOU AS PROVVIGIONE_ALQ,
AL1.TAURAP AS EFFICIENCY_ALQ
FROM
DWH.S26_CARRIER_RATE AL1 WHERE ((NOT AL1.NUMCIE=' '));

left join load * where exists(NUMCIE);
SELECT
AL1.NUMCIE,
AL1.GARANT AS CODICE_GARANZIA,
AL1.DATEFF AS DATA_DECORRENZA_ALQ,
AL1.DATCLO AS DATA_SCADENZA_ALQ,
AL1.TAUCOU AS PROVVIGIONE_ALQ,
AL1.TAURAP AS EFFICIENCY_ALQ
FROM
DWH.S26_CARRIER_RATE AL1 WHERE ((NOT AL1.NUMCIE=' '));

topic Intervalmatch - adding field in QlikView

Intervalmatch - adding field