wrong date field

master_student — Tue, 19 Jul 2016 08:48:46 GMT

Hi guys,

I would like a implement an incremental load ; get the historical records plus result of today's query

below my script:

NoConcatenate

transaction:

load *

from 'transaction_Dist1507.qvd' (qvd);

//LAST modfied date

NoConcatenate

Last_Updated_Date:

load max(STARTOFCHARGINGDATE) as Maxdate

Resident transaction;

//store max date into a variable

let Last_Updated_Date = Peek('Maxdate');

//deletetransactiontable

drop table transaction;

//load incremantal data

OLEDB CONNECT TO [] (XPassword is );

NoConcatenate

transation_tmp:

load

date#(Date( REPORT_DATE, 'DD/MM/YYYY')) as Date_Transaction

;

select

tt.*,

d.aliasname as alias_debit

from (

SELECT

trans.*,

tab.aliasname alias_credit

FROM RECHARGE_PM.POS_REPORT trans , RECHARGE_PM.DUMP_RETAILER tab

WHERE

trans.credit_ACTOR_ID=tab.ACTORE_ID(+)

and report_type = 'TSR001'

and debited_ACTOR_ID IN ($(vActore))

AND FUNCTION = 243 ) tt,RECHARGE_PM.DUMP_RETAILER d

where tt.debited_actor_id=d.actore_id(+)

and tt.STARTOFCHARGINGDATE > $(Last_Updated_Date) ;

NoConcatenate

transaction:

load *,

AutoNumber(date( Date_Transaction,'DD/MM/YYYY'),'%Date ID') as [%Date ID]

resident transation_tmp;

//concatenate with qvd

concatenate

load *

from 'transaction_Dist1507.qvd' (qvd);

//replace old qvd file

store transaction into 'transaction_Dist1507.qvd' (qvd);

drop table transation_tmp;

//script calendar (2015/2016)

The problem is that I didn't get the right Date ID that corresponds with the date field in my qvd (the dates of my transactions are not correct). see what I get:

What do you suggest to fix that?

Thanks in advance.

Re: wrong date field

MK_QSL — Tue, 19 Jul 2016 08:51:23 GMT

Try

and tt.STARTOFCHARGINGDATE > '$(Last_Updated_Date)' ;

Re: wrong date field

master_student — Tue, 19 Jul 2016 08:52:55 GMT

ok, wil try and let you know. Thanks

Re: wrong date field

master_student — Tue, 19 Jul 2016 09:27:06 GMT

The pb seems fixed but I didn't know why I am still getting the wrong date ID for the date 18/07/2016. see bellow:

topic Re: wrong date field in QlikView

wrong date field

Re: wrong date field

Re: wrong date field

Re: wrong date field