Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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);