SFTP and exclusion rules | Community
Skip to main content
EtienneRo
New Participant
Jul 27, 2022 8:36 AM UTC
Question

SFTP and exclusion rules

Hello,

Via a workflow, I retrieve several files on an sftp.
How can I handle the exclusion between these files? For example, if the same person is present in 2 files, I want him to receive only 1 email.

 

I tried putting an exclusion box to remove those who received an email in my workflow but it doesn't work.

 

Could you help me ?

Thanks !

 

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

4 replies

bisswang
Employee
Aug 2, 2022 8:00 PM UTC

Hi,

if you download multiple files using a Single File Transfer activity, then they will be processed "in parallel".

 

What might be done: Store the data in an audience and then process this audience at the end

Translate
EtienneRoAuthor
New Participant
Aug 4, 2022 7:17 AM UTC

My problem is that everything must be managed automatically. Each file will have a common beginning label but the rest will be different. Therefore, I can't select an audience if it changes every time...

Translate
Sukrity_Wadhwa
Sukrity_Wadhwa
Employee
Aug 18, 2022 10:14 AM UTC

Hi @bisswang,

Could you please help @etiennero further on their query?

Thanks!

Translate
Sukrity Wadhwa
Craig_Thonis
Craig_Thonis
Employee
Jul 28, 2022 12:42 PM UTC

Hi Etienneroux,

 

You could try using a Union activity to merge the populations of the files, then adding a Deduplication activity after the Union to remove duplicates based on email address. That would be another straightforward method if the Exclusion activity is not viable.

 

Regards,

Craig

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...