Split on external file

[elenam19306515]

I'm not using the recipients table and I'm sending to a list of email addresses contained in an external data file. I need to do a split and deduplication. How do I do these actions on an external file?

[Jonathon_wodnicki · Accepted solution]

Hi,

Use a Data loading (file) activity in a workflow, then set the delivery to use External file target mapping.

Alternatively, split and dedupe the file itself using csvkit or similar.

Thanks,

-Jon

[elenam19306515]

Thanks very much. I was under that impression too, but I was told by our vendor that "Adobe Campaign doesn't support ad-hoc messaging without a little bit of set-up. It prefers that every communication sent, barring those using the Message Center module, originates from a row in a table living within it." And then was instructed to create a new table schema and target mapping and then import the data to the new table. Any reason for this?