topic Re: Update instead add data in QlikView

Update instead add data

Wed, 30 Oct 2013 16:10:10 GMT

Hi QlikView Experts,

I have a situation where I have to update a value not add a new one. For exemple:

Alarm_ID, Alarm_Start, Alarm_End

1, 10/30/2013 - 09:00, -

2, 10/30/2013 - 09:05, -

After few minutes, QlikView automatically load new data source files, I got:

Alarm_ID, Alarm_Start, Alarm_End

1, 10/30/2013 - 09:00, 10/30/2013 - 09:30

2, 10/30/2013 - 09:05, -

When QlikView finish to load a new file I have the following scenario:

Alarm_ID, Alarm_Start, Alarm_End

1, 10/30/2013 - 09:00, -

1, 10/30/2013 - 09:00, 10/30/2013 - 09:30

2, 10/30/2013 - 09:05, -

But I really need:

1, 10/30/2013 - 09:00, 10/30/2013 - 09:30

2, 10/30/2013 - 09:05, -

How can I fix this ?? I already tried to use the Load Distinct, but I not exaclty what I want.

Regards,

Marcio Alvarez

Re: Update instead add data

Anonymous — Wed, 30 Oct 2013 18:08:00 GMT

Marcio

I think what you want to do here is an incremental load, using Alarm_ID & Alarm Start as the unique key. This can be done with a concatenate and where not exists.

Google, or search this QlikView Community, for QlikView Incremental Load and you should get plenty of hits.

Best Regards, Bill

Re: Update instead add data

Thu, 31 Oct 2013 13:34:59 GMT

Thanks Bill,

This is exactlty what I'm looking for.

Regards,

Marcio