Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SFTP and exclusion rules

Avatar

Level 1

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 !

 

0 Replies

Avatar

Employee Advisor

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

Avatar

Employee Advisor

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

Avatar

Level 1

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