MySQL DB load incremental

[smilingjohn]

Hi All, 

I am trying to Achive incremental load from MySQL DB and it is not working need your advice to resolve this . 

In the MySQL DB the data type for date is "DateTime"  I have fectehd the data and cinverted to QVD and also added Last updated . 

and incremenatl procedure but after completing the records are getting double ? 

Can please someone help me on this 

Thanks in Advance 

[smilingjohn]

@DesmoArka 

Thanks for the reply , But this doesnot work i tried may be the mYSQL query in qlikview requires different date format . 

I tried your solution but still the double records problem . 

[DesmoArka]

Let me know...

You have more records ok, but mySql query works fine? or mySql query extracts all records and so you have double records?

Just to understand if the problem is in qlik or in mySql 🙂

[smilingjohn]

HI @DesmoArka 

I have many records  in mysql Db 

trying manaul date also gives the double data yes it fetches all the data .