Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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);