Qlik Community

QlikView Documents

Documents for QlikView related information.

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
MVP

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

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,

suniljain
Honored Contributor

please check date format of both field in condition.

check the format of "LOAD_DATE" .. try

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

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