Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

create usertable in qlikview

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

1 Reply
prieper
Master II
Master II

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