3

This code returns an generic error - is it not possible to use simple operators to remove rows from a data extension? 

<script type="text/javaScript" runat="server">
    Platform.Load("core", "1");

    var DE_Lead_ExternalKey = "0CFBB346-2E4D-41CF-8649-CFF16A3CB6B2";
    var DE_Lead = DataExtension.Init(DE_Lead_ExternalKey);

    var filter = {Property:"EID",SimpleOperator:"contains",Value:"_temp"};
    var remove_rows = DE_Lead.Rows.Remove(filter);
</script>
Improve this question
3

No. Rows.Remove will only accept an exact value match pair. E.g. "name", "value".

It does not allow for any other simple operators or filters.

Ordinal Type Description
1 string Required Fields used to filter row
2. string Required Values in fields used to filter row

Improve this answer
3
  • 1
    Thank you. I will create a new boolean column and evaluate the value using a query activity, then perform an exact match. When evaluating a boolean field, do I need to include quotes for ordinal 2? e.g. DE_key.Rows.Retrieve(['field_name'],['true']) – Daniel Jun 16 '18 at 15:48
  • No you should be fine with just true – Gortonington Jun 16 '18 at 15:52
  • 1
    I used the DeleteData platform function instead for deleting multiple rows. After some testing, it appears the quotes are required on boolean field values. E.G. DeleteData('DE_Name', ['field_name'], ['True']); – Daniel Jun 16 '18 at 16:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.