create usertable in qlikview

amien — Tue, 10 Nov 2009 18:58:12 GMT

LOAD ID, FirstName, LastName, Group, Deleted, DateDeleted
SQL SELECT * FROM TABLE;

i load this table .. but its refresh each time .. what i want is a new table which adds the new records from TABLE or changes the record in the new table if any item of TABLE is changed.

plus an additional LastMuteDate in the new table. This field is updated if a new record is added or a change is made.

Thanks in advanced

create usertable in qlikview

prieper — Tue, 10 Nov 2009 19:03:30 GMT

Hi,
you may check the OL-Help for sequential load, but for some of your requirements you would need "Last Modified"-field or the like.
Alternatively you may concatenate the existing entries and compare with the SQL-table (AUTONUMBER() and EXISTS() might help), but then you will have to reload the entire table.

Peter

topic create usertable in qlikview in QlikView

create usertable in qlikview

create usertable in qlikview