Aug 23
Someone just asked me how to do this so I am going to post my solution in case it will help others…
Situation: You have a table of email addresses (and that’s it) of clients from the Boston DMA. You want to add a new field called DMA and assign all records the value of “Boston”
Solution: Make a query that includes your email address table. Include email address as one filed and add a new one. The new one will be called DMA and have a value of “Boston”. The SQL would look something like this…
SELECT [EmailList].emailaddress, “Boston” AS DMA
FROM [EmailList];
another option that would make a new table (called dmatable) for the info would be…
SELECT [EmailList].emailaddress, “Boston” AS DMA INTO dmatable
FROM [EmailList];
Similar Posts:
- Analytics Career Newsletter
- How to grow your own analytics team
- Visualize your LinkedIn contacts with InMap
- SugarCRM Debuts Multichannel Marketing, Analytics
- Kaggle hosts data mining competitions
