Dearest Friends and Oh-Wise-Ones,
I recently purchased some demographics data from my friends at Experian for appending our database. I had planned on using the Manage Attribute utility to populate my new attributes of Ethnic Group, Year of Birth, and Mosaic segment. However, as I sat down and started playing, it occurred to me that I can only use the utility to populate a single, particular value at one time.
So for example--I need a list for all folks born in 1979. Another list for folks born in 1980. Another for 1981. And on and on.
While that's not the end of the world (and certainly better than hand-keying each value for each record!), over the course of my 60-someodd-thousand records, I'm creating a lot of individual lists for individual values. And so I'm wondering--is there a better, smarter way to do this?
Any guidance that anyone has to offer is much appreciated!
Thank you,
Brian Jones
Assuming you have a Tessitura customer_no in the Experian data. You could import the data into a staging table and loop through insert the new attributes and values into tx_cust_keyword for that customer (I believe that is where attributes live). Once the bit of code is written it would not take much more then a few minutes to do everyone.
Travis