Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
please help me!!!!
Load SALDO_ITEM_ANIO,
SALDO_ITEM_ENERO,
SALDO_ITEM_FEBRERO,
SALDO_ITEM_MARZO,
SALDO_ITEM_ABRIL
FROM [lib://QVD_BASE_LPH/VIS_ITSA_BI_LPH_SALDOS.qvd]
(qvd);
and I trying to make only in two fields, but only I have date of January of 2019:
for each vMeses in 'ENERO', 'FEBRERO','MARZO','ABRIL'
Concatenate
Load
'$(vMeses)' as Mes_Saldo,
SALDO_ITEM_ANIO,
SALDO_ITEM_$(vMeses) as Saldo_ITEM
FROM [lib://QVD_BASE_LPH/VIS_ITSA_BI_LPH_SALDOS.qvd]
(qvd);
Have you looked at this approach?