Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ecabanas
Contributor II

How to do this table update

     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


Tags (1)