Empty List

[#1]

Hi Team,

Please let me know how can we empty the List after delivery activity.

We are updating the list with 3 days record so "Purge and re-use the list" checkbox is unchecked. 

Our goal is to empty the records in the list once delivery is performed.

Please help me with this.

Thanks in advance. 🙂

[Ritu21]

Hi @Ritu21 - the answer that @wodnicki gave is definitely one way to do it. I found another easy way to do it - just query the List for 0 records then save the List again. It preserves the List schema and purges the list by saving 0 records to it. The query just asks for records where the primary key is empty and the Update List just has the Purge List checkbox ticked.

[Ritu21]

Hi Darren,

Thank you for the reply.

I tried to do that but getting 0 record.

filtered List internal name  and then added query primary key is empty. I am getting 0 records and didn't worked. Could you please let me know where I'm going wrong

[Darren_Bowers]

Hi @Ritu21 - You might need to do a quick load of the List before the query step. This is so you have the actual List schema in the workflow. So the steps would be: Load List > Query 0 records > Save List. This should get you an empty List with the correct schema. Cheers Darren

[Ritu21]

Hi Darren,

I have loaded the list and filtered the data based on primary key as 0.
While clearing the list, I am not getting the list which I have created to delete.
After going through the same, I found that the list whose schema type is "List Of recipient" will only be visible.

Could you please let me know how can I make the schema type as "List Of recipient".
Currently the schema type of the list which I have created is "Recipient" and List type is  "List" not "Group"

List name which I have created : Post Expiration Friday List

While clearing the list : "Post Expiration Friday List" is not coming