Update instead add data

[#1]

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

[Anonymous]

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

[#3]

Thanks Bill,

This is exactlty what I'm looking for.

Regards,

Marcio