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';
