Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to do incremental load with opened_at (Date field) in source it is like (opened_at = '2017-08-02 11:30:45.0000000').
after i doing max(opened_at) as Maxopendate; it is showing like 42949.778564819.
Please see below error i am facing while trying to only newly inserted data with usong opened_at date field,
Can any one suggest.
Thanks,
Rajesh
Hi,
Try converting it into a timestamp like below.
Let vDate = Timestamp(peek('Max',0','Max'),'YYYY-MM-DD hh:mm:ss');
Regards,
Kaushik Solanki
did you tried to convert that into proper date format and do it
Hi,
Try converting it into a timestamp like below.
Let vDate = Timestamp(peek('Max',0','Max'),'YYYY-MM-DD hh:mm:ss');
Regards,
Kaushik Solanki
Format your variable like:
Let vTime=Timestamp(Peek('Maxopendate'), 'YYYY-MM-DD hh:mm:ss.fffffff')
You are mixing date formats. You will have to convert the Qlik timestamp to match the source table time format.
Something like this: date(opened_at,'DD/MM/YYYY hh:mm:ss[.fff]')
Hope this helps.
George
Thanks Kaushik,
but it showing error like below
Hi,
Your variable should be in single quote
Where Field = '$(vVariable)';
Regards,
Kaushik Solanki
Try putting single quotes around variable like:
...
where opened_at > '$(YourVariable)' ;
its done now
Thank u much Kaushik.
Regards
Rajesh