Problemi con CONCATENATE

Wed, 13 Apr 2011 10:49:20 GMT

Ciao a tutti,

ho un problema con il CONCATENATE, cerco di spiegare: cerco di accodare dei dati su una tabella precedentemente legata in join con un'altra tabella. I dati vengono accodati ma senza ritorno (-) sui campi chiave (C_ARTICOLO e C_DIVISIONE). Di seguito riporto il codice utilizzato. Grazie in anticipo a tutti.

TABELLA_1

left join

LOAD *,

TEXT (XCODAR) as C_ARTICOLO,

LEFT(VDATAR,4) AS ANNO,

LEFT(VDATAR,4) AS ANNO_COMP_BDG,

LEFT(VDATAR,4) AS ANNO_COMP,

MID (VDATAR,5,2) AS MESE;

SQL SELECT IDDITTA AS C_DIVISIONE,

FREE02,

XCODAR,

XSTMAE+XSTMNE-(XCLEET+XCMPEE) AS W_COSTO_LAVINT_ULT,

XCLEET AS W_COSTO_LAVEST_ULT,

XCMPEE-XCMPT3 AS W_COSTO_COMP_ULT,

XCMPT3 AS W_COSTO_MP_ULT,

XCEATS AS W_COSTO_A_T_ULT,

XSTMNE AS W_COSTO_MOD_ULT,

XSTMAE AS W_COSTO_PA1_ULT,

XCLEET AS W_COSTO_LA_ULT,

XCMPEE AS W_COSTO_PA2_ULT,

XCMPT3 AS W_COSTO_MP_T_ULT,

XSTMOL AS W_COSTO_MOD_T_ULT,

XSTMOA AS W_COSTO_MODA_T_ULT,

XSTDCL AS W_COSTO_CDL_T_ULT,

XCOAE1 AS W_COSTO_ACC1_D_ULT,

XEOAV1 AS W_COSTO_ACC1_V_ULT,

VDATAR

FROM CDG.dbo."GR_PARCO" WHERE VTIPOR='U' AND FREE02='S2';

DROP FIELDS VDATAR,FREE02, XCODAR;

//°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°

//collegamento costi a tabella

//°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°

CONCATENATE

LOAD IDDITTA as C_DIVISIONE,

TEXT(XCODAR) AS C_ARTICOLO,

ANNO,

ANNO AS ANNO_COMP,

ANNO AS ANNO_COMP_BDG,

MESE,

[COSTO UN] AS W_COSTO_COMP_ULT,

'0' AS W_COSTO_LAVINT_ULT,

'0' AS W_COSTO_LAVEST_ULT,

'0' AS W_COSTO_MP_ULT,

'0' AS W_COSTO_A_T_ULT,

'0' AS W_COSTO_MOD_ULT,

[COSTO UN] AS W_COSTO_PA1_ULT,

'0' AS W_COSTO_LA_ULT,

[COSTO UN] AS W_COSTO_PA2_ULT,

'0' AS W_COSTO_MP_T_ULT,

'0' AS W_COSTO_MOD_T_ULT,

'0' AS W_COSTO_MODA_T_ULT,

'0' AS W_COSTO_CDL_T_ULT,

'0' AS W_COSTO_ACC1_D_ULT,

'0' AS W_COSTO_ACC1_V_ULT

FROM

[\\sgqlik\SMI-QLIK\QLIK-SVIL\VENDITE\QLIK_Costi.xlsx]

(ooxml, embedded labels, table is [Consuntivi mensili])

WHERE [TIPO MOV]='U';

topic Problemi con CONCATENATE in QlikView

Problemi con CONCATENATE