I am looking for a method to add a subscriber(s) to specific publication list. I get the data from Sales cloud contains list of publications subscriber into in DE. Now we are sending them simple email saying you have subscribed into following categories. But before sending them email I need to find a out a way how to add subscriber into specific publication list, he could be a part of one publication list or multiple.
Is this job i can accomplish using Query Activity? Or If export all data from DE onto FTP and then import back directly into specific Publication list (I am not looking for all subscribers list).