Expand my Community achievements bar.

SOLVED

Split on external file

Avatar

Level 1

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Level 1

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?