comparison date field is blank in qlik incremental load

[deep2021]

Hi All,

In the incremental load for the insert logic my date field is showing as a blank.

Below is the piece of code for this.

$(IncrTimestampAttr) >=to_date('$(vL.Last_Exec_$(TableName))', 'YYYY-MM-DD HH:MI:SS')
AND
$(IncrTimestampAttr) <to_date('$(vL.This_Exec_$(TableName))', 'YYYY-MM-DD HH:MI:SS')

I am passing update date to the variable IncrTimestampAttr. 

Do i need to use peek to retrieve for the max value for the variable IncrTimestampAttr.

Can you please suggest in this.

Thanks,

[kaushiknsolanki]

Thanks @Michael_Tarallo  for tagging me.

Dear @deep2021 try this.

$(IncrTimestampAttr) >='$(vL.Last_Exec_$(TableName))'
AND
$(IncrTimestampAttr) <'$(vL.This_Exec_$(TableName))'
;

Do not use the to_date() function and see if that works.

[deep2021]

Hi Kaushik,

After implementing the above changes  It is showing me the below error,

ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-04063: view "VIEW" has errors

Thanks

[Weaver265]

I will ensure that I bookmark your blog and will come back sometime soon.

ACES ETM

[kaushiknsolanki]

I would recommend you to check from the oracle side, what's the issue because from Qlik Query is going properly.

[myestub]

I have seen the first-time Article it is so wonderful thanks for sharing this article.

my estub

[twitchbitstousd1]

I have seen this article this is very nice thanks for sharing it with us.

twitchbitstousd