topic Re: Re: Help in QlikView

Help

NavinReddy — Tue, 27 Aug 2013 03:58:13 GMT

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

Re: Help

Tue, 27 Aug 2013 05:18:35 GMT

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?

Re: Help

MayilVahanan — Tue, 27 Aug 2013 05:36:10 GMT

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

Re: Help

NavinReddy — Tue, 27 Aug 2013 06:16:53 GMT

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

Re: Help

NavinReddy — Tue, 27 Aug 2013 06:59:38 GMT

Hi All,

If any modifications in Qvw

some one help me to find Solution

Thanks & Regards

Rohith

Re: Re: Help

Tue, 27 Aug 2013 07:12:11 GMT

See the attachment.

Re: Help

NavinReddy — Tue, 27 Aug 2013 07:28:19 GMT

Hi Venu,

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

and same as Deleted Records also

Thanks & Regards

Rohith

Re: Help

Tue, 27 Aug 2013 07:32:26 GMT

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.

Re: Re: Help

Tue, 27 Aug 2013 09:21:40 GMT

Hi,

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