Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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);