Split on external file | Community
Skip to main content
elenam19306515
elenam19306515
August 19, 2019
Solved

Split on external file

  • August 19, 2019
  • 2 replies
  • 1402 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    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

    2 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    August 20, 2019

    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
      elenam19306515Author
      August 20, 2019

      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?

      Terms & ConditionsAccessibility statement

      Loading footer...