topic Re: incremental load in QlikView

incremental load

NavinReddy — Thu, 14 Nov 2013 07:35:06 GMT

Hi All,

Incremental load where can we get Updated records

it mean which line of code

Thanks in Advance

Niranjan

Re: incremental load

kaushiknsolanki — Thu, 14 Nov 2013 07:37:52 GMT

Hi,

Do you mean, How to implement the Incremental load?

or you want to know what does incremental load means ?

Regards,

Kaushik Solanki

Re: incremental load

sasikanth — Thu, 14 Nov 2013 07:57:16 GMT

hi niranjan ,

--------------------------------------------------------------------------------

EMP_Load:

select * from MSBI.DBO.Employee

where HireDate>$(MaxDate1);

load * from D:\EMP_inc.QVD(qvd)

where not Exists(employee_id);

inner join (EMP_Load)

select * from MSBI.DBO.Employee;

------------------------------------------------------------------------------------

Here we will get newly or updated records ...

Re: incremental load

NavinReddy — Thu, 14 Nov 2013 08:06:04 GMT

No, while using incremental load how can we get incremental load,

i.e, where modification time>reloadtime(); wherenot exits.

what should i suppose to say if some one ask

plz help me

thanks,

Niranjan

Re: incremental load

kaushiknsolanki — Thu, 14 Nov 2013 08:12:04 GMT

Hi,

Do you mean that you want to have the understanding of the script how it works?

Then this is the best example, have a look at the attached presentation and also below vid.

http://www.learnqlickview.com/incremental-data-load-in-qlikview/

Regards,

Kaushik Solanki

Re: incremental load

sasikanth — Thu, 14 Nov 2013 08:14:32 GMT

i didnt get u niranjan can u please explain me more ...

Re: incremental load

NavinReddy — Thu, 14 Nov 2013 08:28:30 GMT

yes i got it,for your reply

Thanks for your giving valuable information

R egards

Niranjan