delete record by data distiller

Hello @pradeep-jaiswal 

Data Distiller can create a new dataset based upon a conditional statement.  It does not allow for the deletion of records from the profile store and or datalake.  

If you are looking to remove records from a the Adobe Experience Platform profile store an option to consider is the following:

1) Create a new dataset which is marked for profile

2) Insert records from initial dataset into new dataset created in item 1, using where condition collect records which meet specific criteria.

3) Delete original dataset via Adobe Experience Platform UI.  This deletion action will delete the dataset and delete the records from the unified profile store.

@pradeep-jaiswal if you are looking at deleting profiles records Advanced Data Lifecycle Management or Data Hygiene API guide is better.

You can still not delete data based on _id but you can use the corresponding ECID or any other profile id to lookup the data and delete.

Probably, you can get the list of Profile ids for the corresponding _Id values you have in Query Service.