Skip to main content
elenam19306515
elenam19306515
Aug 19, 2019 9:47 PM UTC
Solved

Split on external file

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.
    Jonathon_wodnicki
    Jonathon_wodnickiAccepted solution
    Community Advisor
    Aug 20, 2019 2:54 PM UTC

    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 in thread

    2 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    Aug 20, 2019 2:54 PM UTC

    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

    Translate
      elenam19306515
      elenam19306515Author
      Aug 20, 2019 9:40 PM UTC

      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?

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...