topic How to do this table update in QlikView

How to do this table update

ecabanas — Tue, 28 Jul 2015 14:50:19 GMT

Hi guys,

I want to do a table that reflects all the changes from items table. Every Item can change the status every day and I want to do a "log Table" and record the changes in a table and have all history.

Every night I want to update (add the new changes) the table.

INVENTTABLE

Itemid Date Status

a 1/1/15 on

b 1/1/15 on

c 1/1/15 off

d 1/1/15 on

ITEM_LOG

Itemid Date Status

a 1/1/15 on

b 1/1/15 on

c 1/1/15 off

d 1/1/15 on

DAY 2 change some items

INVENTTABLE

Itemid Date Status

a 2/1/15 on

b 2/1/15 off

c 2/1/15 on

d 2/1/15 on

ITEM_LOG

Itemid Date Status

a 1/1/15 on

b 1/1/15 on

c 1/1/15 off

d 1/1/15 on

b 2/1/15 off

c 2/1/15 on

Many thank's

Eduard