SFTP and exclusion rules | Community
Skip to main content
New Member
July 27, 2022
Question

SFTP and exclusion rules

  • July 27, 2022
  • 2 replies
  • 1305 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

Craig_Thonis
Adobe Employee
Adobe 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

Adobe 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

EtienneRoAuthor
New Member
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
Community Manager
Community Manager
August 18, 2022

Hi @bisswang,

Could you please help @etiennero further on their query?

Thanks!

Sukrity Wadhwa