Understanding split activity

[KD1]

Hi @ParthaSarathy 

I have a scenario where a recipient has opened a single delivery multiple times, and I need to fetch only the top records for each recipient. For example:

Recipient | Date

1 | 12/28

2 | 12/27

3 | 12/26

I need to retrieve only the first two records for each recipient. I am trying to use the Split activity in Adobe Campaign Classic, but I am unable to achieve the desired results. Could you please help me

with this using split activity only, as I am trying to understand how split activity work?

[ParthaSarathy · Accepted solution]

Hi @KD1 ,

For your use case, Deduplication activity is the right one to use.

Deduplication activity > select temporary schema > in 'identification of duplicate's window select recipient's primary key > next > in 'Deduplication method's window, select method as 'using an expression' and 'expression: ' select @logDate and select 'keep the records with largest value' radio button.

Now the result of Deduplication will be unique recipients with latest log date record.

[KD1]

Hi @ParthaSarathy 

Thank you for quick reply.

Actually I want to explore the split activity, can it be possible using the method I am trying to do?

It will be really helpful for me to understand the split activity more.

[ParthaSarathy]

@KD1 , for your scenario use Deduplication activity.

To explore split activity and it's functionality, refer this document to know more about split activity with example scenario.

[KD1]

Hi @ParthaSarathy 

Upon exploring split activity, having few doubts

In general tab of split activity in filtering settings what does below option defines

1.Use data from the target and additional data

2.Use the additional data only

What difference it makes selecting either of above option, a simple example from you will clear my doubt. I’ve often been advised to use the second option but am unsure why. Also advise when option 1 and 2 will be required.

Looking forward to your response.