Combination of Products and summation of the counts of respective products as shown in description.

Question

We have the data in the below-shown format:

Product 1	Count 1	Product 2	Count 2
A	2	D	1
B	3	E	2
C	1	F	1

like we have headers for Product 1 and Count 1 in a transition and Product 2 and Count 2 in another transition and we need results in the below shown format.

Product Combo	Count
AD	Sum of Count A and Count D
AE	Sum of Count A and Count E
AF	Sum of Count A and Count F
BD	Sum of Count B and Count D
BE	Sum of Count B and Count E
BF	Sum of Count B and Count F
CD	Sum of Count C and Count D
CE	Sum of Count C and Count E
CF	Sum of Count C and Count F

Is there any way to do this in Adobe Campaign Classic without using js activity.

AnanthanJa · Accepted Answer

Hi @saurabh99,

You can perform a Cartesian join using an enrichment activity.

In this case, you can join the product schema with itself using the condition as 1=1 i.e., both the source and target values are hard coded as 1.

This will yield additional records where the linked data is all blank. You can filter the same using split activity. Then you can use enrichment to add the sum.

Image of the workflow

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded