Fields

[olguita2014]

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

[sunny_talwar · Accepted solution]

Have you looked at this approach?

The Crosstable Load