topic Re: Incremental load in QlikView

Incremental load

Wed, 16 Apr 2014 11:46:08 GMT

Need to do an incremental load,

MFD:

LOAD

$(Emp) & '-' & ZS_FILIAL&ZS_DATA&ZS_IMPRESS AS %linkMFD,

ZS_FILIAL as CodFilialMFD,

ZS_ALIQICM as AliqMFD,

ZS_CUPOM as CupomMFD,

MID(ZS_DATA,1,4) AS Ano,

$(Emp) & '-' & ZS_FILIAL as CodEmpFilZS,

MONTH(MAKEDATE(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2))) AS Mes,

MID(ZS_DATA,7,2) AS Dia,

date(MAKEDATE(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2),MID(ZS_DATA,7,2))) AS Data,

weekday(MAKEDATE(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2),MID(ZS_DATA,7,2))) AS DiaSemana,

ceil(MONTH(MAKEDATE(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2))),4) AS Trimestre,

MonthName( MakeDate(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2),MID(ZS_DATA,7,2))) AS MesAno,

ZS_ITEM AS ItemMFD,

ZS_PDV as PdvMFD,

ZS_IMPRESS as ImpressMFD,

ZS_PRODUTO AS DescProdutoMFD,

ZS_QTDADE AS QuantidadeMFD,

ZS_STATUS AS StatusMFD,

ZS_TIPO AS TipoMFD,

ZS_VLRBASE as ValBaseIcmMFD,

ZS_VLRICMS as ValorIcmMFD,

ZS_VLRTOTA AS TotalMFD,

ZS_VLRDESC AS ValorDescMFD,

ZS_VLRUNIT AS ValorUniMFD;

SQL SELECT ZS_ALIQICM,

ZS_CODPROD,

ZS_CUPOM,

ZS_DATA,

ZS_FILIAL,

ZS_IMPRESS,

ZS_ITEM,

ZS_PDV,

ZS_PRODUTO,

ZS_QTDADE,

ZS_STATUS,

ZS_TIPO,

ZS_VLRBASE,

ZS_VLRICMS,

ZS_VLRTOTA,

ZS_VLRDESC,

ZS_VLRUNIT

//FROM SigaProdp10.dbo.SZS010;

FROM SZS$(Emp)0 SZS

WHERE

D_E_L_E_T_ <> '*'

AND ZS_DATA >= '20130401'

AND ZS_DATA <='20131231';

STORE * FROM MFD into MFD$(Emp).QVD (qvd);

DROP Table MFD;

Re: Incremental load

magavi_framsteg — Wed, 16 Apr 2014 11:48:46 GMT

Hi Saniffer.

Have you tried lurking the forums?

Re: Incremental load

Wed, 16 Apr 2014 11:50:04 GMT

yeah, so I'm not getting applied to my reality

Re: Incremental load

Wed, 16 Apr 2014 11:55:53 GMT

Thanks, found in Incremental load in Qlikview

Re: Incremental load

fernando_tonial — Wed, 16 Apr 2014 11:59:57 GMT

Hi, try this.

Check the code:

LET vDataInicio = Date(YearStart(Today()),'YYYYMMDD');
LET vDataFim = Date(Today(),'YYYYMMDD');

MFD:
LOAD 
    $(Emp) & '-' & ZS_FILIAL&ZS_DATA&ZS_IMPRESS AS %linkMFD,
    ZS_FILIAL as CodFilialMFD,
    ZS_ALIQICM as AliqMFD,
    ZS_CUPOM as CupomMFD,
    MID(ZS_DATA,1,4) AS Ano,
    $(Emp) & '-' & ZS_FILIAL as CodEmpFilZS,
    MONTH(MAKEDATE(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2))) AS Mes,
  MID(ZS_DATA,7,2) AS Dia,
  date(MAKEDATE(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2),MID(ZS_DATA,7,2))) AS Data,
  weekday(MAKEDATE(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2),MID(ZS_DATA,7,2))) AS DiaSemana,
  ceil(MONTH(MAKEDATE(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2))),4) AS Trimestre,
  MonthName( MakeDate(MID(ZS_DATA,1,4),MID(ZS_DATA,5,2),MID(ZS_DATA,7,2))) AS MesAno,
    ZS_ITEM AS ItemMFD,
    ZS_PDV  as PdvMFD,
    ZS_IMPRESS as ImpressMFD,
    ZS_PRODUTO AS DescProdutoMFD,
    ZS_QTDADE AS QuantidadeMFD,
    ZS_STATUS AS StatusMFD,
    ZS_TIPO   AS TipoMFD,
    ZS_VLRBASE as ValBaseIcmMFD,
    ZS_VLRICMS as ValorIcmMFD,
    ZS_VLRTOTA AS TotalMFD,
    ZS_VLRDESC AS ValorDescMFD,
    ZS_VLRUNIT AS ValorUniMFD;
SQL SELECT ZS_ALIQICM,
    ZS_CODPROD,
    ZS_CUPOM,
    ZS_DATA,
    ZS_FILIAL,
    ZS_IMPRESS,
    ZS_ITEM,
    ZS_PDV,
    ZS_PRODUTO,
    ZS_QTDADE,
    ZS_STATUS,
    ZS_TIPO,
    ZS_VLRBASE,
    ZS_VLRICMS,
    ZS_VLRTOTA,
    ZS_VLRDESC,
    ZS_VLRUNIT
//FROM SigaProdp10.dbo.SZS010;
FROM SZS$(Emp)0 SZS
WHERE
  D_E_L_E_T_ <> '*' 
  AND ZS_DATA >= '$(vDataInicio)'
  AND ZS_DATA <='$(vDataFim)';

LOAD * FROM MFD$(Emp).QVD (qvd);

STORE * FROM MFD into MFD$(Emp).QVD (qvd);
DROP Table MFD;

Best Regards.

Tonial.