Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

incremental load issue while executing

Not applicable

incremental load issue while executing


FACT_DQ_PSD_DTL:SQL SELECT "BATCH_IN_ID",
    "COMPLETENESS_PCT",
    "CONFORMITY_PCT",
    "CORRECTNESS_PCT",
    "DATA_ORIGIN_KEY",
    "IMPACTED_NET_CREDITABLE_AMT",
    "ISO_COUNTRY_CD",
    "LOAD_DATE",
    "OVERALL_PCT",
    "QUOTA_PRODUCT_LINE_CODE",
    "REPORTER_ROW_ID",
    "SHIP_DATE",
    "SQDC_TRANSACTION_KEY",
    "SYSTEM_ORIGINATOR_CD",
    "VALIDITY_PCT"
FROM MYCOMPDQC."FACT_DQ_PSD_DTL" where "LOAD_DATE">ReloadTime();//(“Here it showing invalid reloadtime ” this is the error how can I solve it )ConcatenateLOAD  Distinct SQDC_TRANSACTION_KEY,
    
REPORTER_ROW_ID,
    
SHIP_DATE,
    
BATCH_IN_ID,
    
LOAD_DATE,
    
DATA_ORIGIN_KEY,
    
SYSTEM_ORIGINATOR_CD,
    
QUOTA_PRODUCT_LINE_CODE,
    
ISO_COUNTRY_CD,
    
COMPLETENESS_PCT,
    
CORRECTNESS_PCT,
    
CONFORMITY_PCT,
    
VALIDITY_PCT,
    
OVERALL_PCT,
    
IMPACTED_NET_CREDITABLE_AMTFROM
[..\QVDsofQVW1\FACT_DQ_PSD_DTL.qvd]
(
qvd)where not Exists( SQDC_TRANSACTION_KEY) ;
STORE FACT_DQ_PSD_DTL into C:\Users\skuma\Desktop\QVDsofQVW1\FACT_DQ_PSD_DTL.qvd(qvd);

above which is i mention in yellow that is my problem please solve it.

Thanks,

Tags (1)
Labels (1)
Comments
MVP & Luminary
MVP & Luminary

Hi,

you have to quote the result of ReloadTime() and maybe also to cast to a timestamp datatype with the appropriate database cast/convert function (eg. to_date() in Oracle).

First try with $-expansion expression: "LOAD_DATE" > '$(ReloadTime())';

- Ralf

0 Likes
Not applicable

Hi Ralf,

It exe cuting but i am not able to see in log file i have some doubt it is properly working r not but the format is ok

please give me any way for do this incremental load by db table.

Thank u,

0 Likes
suniljain
Honored Contributor

please check date format of both field in condition.

0 Likes

check the format of "LOAD_DATE" .. try

let vReloadtime = reloadtime()
"LOAD_DATE" > to_date('$(vReloadtime)' ,'DD-MMM-YYYY');

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2013-08-12 10:40 PM
Updated by: