Fields

olguita2014 — Fri, 02 Apr 2021 07:49:09 GMT

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

Re: Fields

sunny_talwar — Fri, 22 Feb 2019 13:50:59 GMT

Have you looked at this approach?

The Crosstable Load

topic Re: Fields in App Development

Fields

Re: Fields