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

[saurabh99]

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 solution]

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

[saurabh99]

Thank you for sharing this logic.