Skip to main content
E
EtienneRo
New Participant
July 27, 2022
Question

SFTP and exclusion rules

  • July 27, 2022
  • 2 replies
  • 1303 views

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.

2 replies

B
bisswang
Employee
August 2, 2022

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

E
EtienneRoAuthor
New Participant
August 4, 2022

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...

Sukrity_Wadhwa
Sukrity_Wadhwa
Employee
August 18, 2022

Hi @bisswang,

Could you please help @etiennero further on their query?

Thanks!

Sukrity Wadhwa
Craig_Thonis
Craig_Thonis
Employee
July 28, 2022

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

    Terms & ConditionsAccessibility statement

    Loading footer...