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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
KumaRan
Contributor III
Contributor III

Deleting bulk values from data modelling

Hi all,

I need to delete set of bulk values from data model.say for example ID from data model.set of ID's to be deleted is available in Excel.

can any one suggest me?

Labels (2)
1 Reply
gbommisetti
Contributor II
Contributor II

First load the .csv file and then use where not exists:

csv:

load id from csv;

Table:

load * from QVD where not exists(id);