If you ever need an automated way to clear a data extension, you can simply use a SQL query that does an overwrite. The query doesn’t need a from clause if you specify any required columns in the target.

For example, if EmailAddress is required in the target data extension, simply set the value to null and add an alias:

See the gist on github.
Published by
Adam Spriggs @wvpv

Recent Posts

  • AMPScript
  • Salesforce Marketing Cloud
  • Server-side JavaScript

Updating Salesforce Objects with Server-Side JavaScript

If the custom preference center in your integrated Marketing Cloud account needs to update Salesforce object attributes, you're probably acquainted…

2 weeks ago
  • sports

Giannis is the 2018-19 NBA MVP

https://www.youtube.com/watch?v=2OZZp3k_EqI I'm so happy for him and for the future of the Milwaukee Bucks. Always want more but never be…

3 weeks ago
  • food

How to dice an onion

https://youtu.be/CwRttSfnfcc Chef Jean Pierre demonstrates the proper way to dice an onion.

3 weeks ago
  • fun

Wanna box?

Wanna box for those, Sir? Nah, I hate violence. Is it cool if I just pay with my card?

2 months ago
  • fun
  • inspiration

I’ll have what he’s having, part 12

https://www.youtube.com/watch?v=vC8gJ0_9o4M South Pole trekker Aleksander Gamme revisiting a stash he left for himself a month earlier. Be sure and turn…

3 months ago