Help

[NavinReddy]

Hi All,

could some one help me to solve this issue in incremental load

i am not getting if record is updated or deleted

plz find the attachment

Thanks in Advance

Rohith

[#2]

Hi,

it seems, the newly added ModificationTime field values are not in same format. Take a look at your excel sheet.

And one more question, why you need Inner join?

[MayilVahanan]

Hi Niranjan123,

Your modificationtime field is not in same date format. And  reloadtime() function gives date and time value.

26/08/2013 is in text format, not in date format.

Check the date format and use date(Floor(reloadtime())) function in where condition.

Hope that helps

[NavinReddy]

Hi Mayil,

if i change that date 27/08/2013 it wont update

im not getting that format in where condition

plz update in QVW and attechment me

Thanks & Regards

Rohith

[NavinReddy]

Hi All,

If any modifications in Qvw

some one help me to find Solution

Thanks & Regards

Rohith

[#6]

See the attachment.

[NavinReddy]

Hi Venu,

Thanks for your reply but i not getting updated records in Excel

and same as Deleted Records also

Thanks & Regards

Rohith

[#8]

Hi,

Ohh, I am sorry to not mention about the field "ModificationTime". I have added the data with same format of existing values in modificationTime and i succeeded.

Also, try to put the code in debug and find how the execution of reload is going on.

[#9]

Hi,

Could you please take a look at attachment. I hope now you can able to load the recent updated data.